Monthly Archives: January 2024

Building a Contextual Back Button with Application Page Items in Oracle APEX

Overview In ORACLE APEX we generally use page number in the URL to redirect the page from one to another. However in this session dives deep into the hidden potential…

Read More

Enforcing Save Before Adding New Row in Oracle APEX Interactive Grid using JavaScript

Overview In Oracle APEX, a interactive grid had a concept of adding multiple row. Here in some cases the specific requirement here is to insert only one record at a…

Read More

EMPLOYEES HOLIDAY CALENDAR LIST (Core HCM)

Introduction:  This SQL query is used to fetch the Holidays list for Employees like Employee number, Holiday name, Start date, End date etc… Cause of the issue: Business wants a…

Read More

EMPLOYEE SALARY DETAILS QUERY (Core HCM)

Introduction:  This SQL query is used to fetch the data of Employees Salary details (CTC)like Annual salary, Fixed CTC, Employee number, DOJ, Base element name etc ..   Cause of…

Read More

Projects Import FBDI Query in Oracle Fusion ERP Cloud

Introduction: This blog has Projects Import FBDI Query that can be used to retrieve data as per Projects FBDI Format in Oracle Cloud application.   Cause of the issue: Business…

Read More

Customer Name Mass Update Using REST API – Oracle Fusion ERP Cloud

Introduction: This blog has the REST API details that can be used to update the customer’s name in Oracle Cloud application.   Cause of the issue: Business wants to mass…

Read More

Query to find out the Request Set of a Program and its details in EBS R12

Objective The intent of this document is to find out the request set name of given concurrent Program and the details of programs attached in the Request Set. Why we…

Read More

Query to find out the Receiving Transaction Interface error details in EBS R12

Objective The intent of this document is to find out the error’s details when standard Program not able to process the records in interface table (RCV_TRANSACTIONS_INTERFACE). Why we need to…

Read More

Query to Display the Concurrent Program’s which has are modified at XML Data_Defination_level or LOB’level

Introduction:   This query is used to fetch the list of  concurrent program names which are having the changes at XML Publisher level (Data_Definition or Template Level) which also includes…

Read More

FNDLOAD command to download and upload LDT file for a Concurrent Program

FNDLOAD command to download and upload LDT file for a Concurrent Program Introduction:  It is generally time-consuming process and task to create same setup data on each instance separately. Hence…

Read More