You can also view the Oracle application post in more ordered manner at below link
EBS R12 is supported in Multitenant mode for Oracle Database 19c. If you try to generate a tkprof to report explain plan generation on the Database, you will receive errors for the Invalid username /password in the trace file generated tkprof test.trc test.txt sys=no explain=apps/apps sort=prsela,exeela,fchela The reason for this is that apps is the …
How to generate tkprof in EBS in 19c Read More »
Sometimes users get performance issues during various pages in the Oracle Apps application. We need to take the trace of the problem in order to identify the bottleneck We can execute the below steps to generate the database level trace for the issue and find out the culprit sql or statement. Here is how to …
We generally write FND_FILE statements in concurrent programs for debugging, logs, and various other messages These are visible in Concurrent request logs and out once the concurrent program completes only If we want to see the logs and out for the running concurrent request, then we need to find the temporary log and out file …
How to find the FND_FILE output of the running concurrent request Read More »
We often need to clone the R12.1 environment to create another test environment. Here are the steps on How to clone R12.1 Environment Step 1: Prepare the Source System database tier for cloning 1. Log on to the Source System as the Oracle user.2. Source the Database tier environment file. cd <RDBMS ORACLE_HOME>/appsutil/scripts/<CONTEXT_NAME>perl adpreclone.pl dbTier This …
XMLImporter and FndXdfCmp are the implement utilities in Oracle E business Suite for implementing new OAF pages and new schema definition and changes XMLImporter is used for new OAF pages and personilization in the oracle database while FndXdfCmp is used for new schema definition and changes Here are the steps on how to use XMLImporter and …
how to use XMLImporter and FndXdfCmp in Oracle EBS Read More »
With 11gR2, Oracle has introduced Edition-based redefinition to help in online modification. R12.2 Online Patching also uses the same feature to achieve Online patching.in R12.2 Editions are synced between the OS filesystem and database Two Edition Definitions Runtime: Used by Online Users, Never changed by a PatchPatch: Used by the Patching Tools, Changes do not …
R12.2 Edition determination and setup Read More »
