EBS

Oracle Internet Of Things (IoT)

Dear Readers I would like to explain more about the Oracle IoT Cloud services. Will provide continues blogs on this technology. In this block we will explore what is IOT…

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

Auditing in Oracle E-Business Suite

  Navigating Auditing in Oracle E-Business Suite:   Introduction: Oracle E-Business Suite (EBS) is a powerful enterprise resource planning (ERP) solution that manages a wide range of business processes. Ensuring…

Read More

Active EBS users and their respective responsibilities in Oracle E-Business Suite

Every time a customer or client asks for a list of EBS Users and their responsibilities, the DBA team would generally execute the “Active Users” Concurrent Program from the System…

Read More

Enhancing Log and Output File Management in Oracle E-Business Suite 12.2

Introduction: Effectively managing large log and output files is crucial for maintaining optimal performance in Oracle E-Business Suite 12.2. Despite the availability of purge programs to address both database and…

Read More

Identify versions of components in EBS

Useful commands to find the versions of various components used in Oracle E-Business Suite Find Apache Version or Oracle Application server version in R12 Log in to the Application server…

Read More

How to Expose Custom PL/SQL API as a REST Webservice? 

How to Expose Custom PL/SQL API as a REST Webservice?  Oracle E-Business Suite Integrated SOA Gateway (ISG) provides an infrastructure to deploy, consume, and administer Oracle E-Business Suite web services.…

Read More

R12 – Accounting Setup Manager Checklist

r12_setup_check_list Accounting Setup Manager Checklist  The following table describes the steps to create accounting setups using Accounting Setup Manager. Each required setup step must be completed before you can complete…

Read More

Query to fetch Routing Details

Introduction: Routing is a set of operations that will be performed in sequence to manufacture an assembly Item. The below query will give the operation sequence details.   Query to fetch…

Read More