Travel Expenses Query – Fusion Expense Module
Introduction: This blog has the SQL query that can be used to pull Travel expense data from Fusion Expense Module. Cause of the issue: Business wants a report that contains travel expense details ...
Employee Expenses Query – Fusion Expense Module
Introduction: This blog has the SQL query that can be used to pull employee expenses data from Fusion Expense Module. Cause of the issue: Business wants a report that contains consolidated ...
SSH Key Upload in Oracle Fusion
When we use SSH keys for authenticating third party servers, the Public key will be configured in third party server whereas Private key will be configured in Oracle BI Publisher along with ...
SSH Key Generation for Third Party Server Authentication
It’s a secure access credential used in the Secure Shell (SSH) protocol. This is one of the authentication methods that Oracle uses to communicate with third party server such as sFTP. Steps to ...
Create PO Change Order in Oracle Cloud – Add New Line To Existing PO Using SOAP request
This blog describes the sample request for creating Change Order in Oracle Cloud for the existing Purchase Order. This Change Order creates new line to the existing PO. Before moving to the ...
Create PO Change Order in Oracle Cloud – Add Project Info To Existing PO Line Using SOAP request
This blog describes the sample request for creating Change Order in Oracle Cloud for the existing Purchase Order. This Change Order is to add project details in PO line and distribution level. ...
Manage IN and OUT Time Events Using REST API – Oracle Cloud OTL
The timeRecordEventRequests REST API requires both IN and OUT time to be supplied in the payload to create time entries in Oracle OTL. In real time clock integrations with Oracle, clock systems ...
Oracle Time Entries Creation Using REST API
Oracle Time and Labor (OTL) – Time Entries Creation Using REST API When we have a requirement to integrate Oracle Time and Labor with external clocks of employee IN/OUT register for ...
User Status Query – Oracle Fusion
The below query extracts the list of employee users along with their user status and employee status SELECT pu.username USER_NAME ,papf.person_number EMPLOYEE_NUMBER ,ppn.first_name ...
Query to get list of Data Accesses of users – Oracle Fusion
The below query extracts the list of data accesses given for any user in Oracle Cloud Application ...
