We have already read about the Oracle cursor in the below post What is the cursor in oracle Let’s check about the oracle cursor for loop. How it is beneficial and How to use it in PLSQL Oracle Cursor FOR Loops in oracle 1)The cursor FOR loop is a shortcut to process Explicit cursors 2) […]
What is oracle cursor for loop Read More »
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 »
“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 »
(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 »
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 »
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 »
