Preventive Maintenace Work Order
Breakdown Maintenance A.1 N> Enterprise Asset Management > Work Order Sub Menu > Work Order Definition >Open A.2 Click NEW for creation of New work order A.3 Enter…
Read MoreCountry wise Catalog and Non Catalog Po’s in Oracle EBS
Introduction:- Using the below SQL script we can get the Catalog and Non Catalog Po’s details from country wise. Code:- SELECT P.SEGMENT1 “PO Number” ,PL.LINE_NUM “PO Line”,TO_CHAR(P.CREATION_DATE,’DD-MON-RRRR HH24:MI:SS’) “PO Created…
Read MoreOracle 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 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 MoreAuditing 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 MoreActive 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 MoreEnhancing 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 MoreIdentify 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