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 MoreProjects 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 MoreCustomer 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 MoreQuery 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 MoreQuery 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 MoreQuery 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 MoreFNDLOAD 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 MoreA Dynamic Scaling Solution for Batch Processing Workloads
Problem: Traditional batch processing setups often face resource inefficiencies, as they are provisioned statically, leading to underutilization during low-demand periods and potential bottlenecks during peak times. Manually adjusting resources is…
Read MoreManaging Infrastructure Complexity with Terraform Modules
Problem: In a rapidly evolving and dynamic IT environment, managing complex infrastructure configurations across various projects and environments can be daunting. A monolithic approach to Terraform scripts may lead to…
Read MoreOracle EBS – Query to get Price list details for 5 Years
Execute the below query into EBS database. SELECT line, empty, pricing, item, from_date, TO_DATE, total, uom, attirubute, org FROM (SELECT ‘NL’ line, ” empty, ‘INTERCOMPANY PRICING’ pricing, item.segment1 item,…
Read More