Posts by Anand Kumar

Query to get Data Accesses of Users – Oracle Fusion

Introduction: This blog has the SQL query that can be used to pull the data access details of all the users irrespective of their status. Cause of the issue: Business…

Read More

Employee Recall Query – Oracle Fusion

Introduction: This blog has the SQL query that can be used to pull the data of employees who are recalled to join the organization. Cause of the issue: Business wants…

Read More

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…

Read More

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…

Read More

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…

Read More

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…

Read More

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…

Read More

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…

Read More

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,…

Read More

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…

Read More