Useful Oracle provided sql scripts for R12.2

Oracle provides a suite of built-in SQL scripts for E-Business Suite R12.2 to assist DBAs with advanced diagnostics and troubleshooting. Located primarily in the AD and FND directories, these scripts allow administrators to safely query the dual-file system, validate concurrent manager statuses, and generate critical system health reports for Oracle Support All the below scripts […]

Useful Oracle provided sql scripts for R12.2 Read More »

Important Profiles for Oracle Application Framework(OAF)

“To enable OAF personalizations and diagnostics in modern Oracle E-Business Suite environments, administrators must configure specific profile options. Set ‘FND: Personalization Region Link Enabled’ and ‘Personalize Self-Service Defn’ to Yes at the User level to reveal the Personalize Page link. For UI debugging, enable ‘FND: Diagnostics’ to access the critical ‘About This Page’ details.” I

Important Profiles for Oracle Application Framework(OAF) Read More »

How to Perform a Oracle JVM Re-installation to Multitenant Database

(1) Create a working directory for this activity. mkdir /tmp/jvmcd /tmp/jvm Note : All scripts should be created and executed in directory /tmp/jvm . If you choose to do this activity in some other directory, then change the same path in all scripts. (2) Create below scripts. a. Create script jvm_info.sql to check JVM status.

How to Perform a Oracle JVM Re-installation to Multitenant Database Read More »

Oracle EBS with Oracle Database 19c frequently Asked Questions

Now Oracle EBS is certified to use with Oracle database 19c(19.3). Also, A CDB with one PDB (single-tenant) is currently the only certified deployment for Oracle E-Business Suite with Database 19c. So oracle database has to be multitenant on Oracle 19c. Many questions come when it comes to using Multitenant database with EBS like how

Oracle EBS with Oracle Database 19c frequently Asked Questions Read More »

How to download Oracle E-Business suite 12.2 software

To download the current Oracle E-Business Suite 12.2 software, log in to the Oracle Software Delivery Cloud (edelivery.oracle.com) using a valid Oracle Single Sign-On account. Search for “Oracle E-Business Suite,” select the 12.2 release for your target operating system, and add it to your queue. For the most reliable transfer, generate the Wget script from

How to download Oracle E-Business suite 12.2 software Read More »

How to generate EPM Deployment Report

To generate a deployment report for an on-premises Oracle EPM System, open a command prompt on the Foundation Services host machine. Navigate to the EPM_ORACLE_INSTANCE/bin directory and execute the command epmsys_registry report deployment. Oracle will generate an HTML file detailing your deployment topology, which is saved in the EPM_ORACLE_INSTANCE/diagnostics/reports directory. In modern Oracle EPM 11.2

How to generate EPM Deployment Report Read More »

Scroll to Top