Compiling APPS Schema in Oracle Applications R12

Compiling APPS Schema in Oracle Applications R12

Introduction:

Compiling APPS Schema means compiling invalid database objects in the APPS schema, in other words compiling uncompiled program units (PL/SQL and Java) in the APPS schema. Uncompiled objects in other schemas such as SYS and SYSTEM are not necessarily compiled. This task doesn’t take much time but sometimes it takes fairly much time.

Normally the database will “lazily” compile these objects when accessed, but normally you can perform this action before the database do (before accessed by users) to:

Find truly invalid objects before users get a runtime error.
Increase runtime performance.


Compiling APPS Schema

The steps to compile the APPS schema are straight forward using the adadmin utility. Here are the steps for Oracle Applications R12 on UNIX:

1) Start adadmin utility

Start Database & listener
Switch user to applmgr & Run the environment
Start Adadmin utility $ adadmin

2) Select option [3] Compile/Reload Applications Database Entities.

3) Select option [1] Compile APPS schema.

4) At the prompts, enter a value for the number of workers or simply accept the default value

Enter the number of workers [4]: <Hit Enter>
Run Invoker Rights processing in incremental mode [No]? <Hit Enter>

5) Check for errors and warnings.

In the AD Administration log file, search for the words “error” and “warning”.
If there are errors, you will need more investigation to determine what caused them and then find a solution for them, you can use Metalink to search for errors.

Note: You can compile the apps schema while the application is up and running (unless you have major issues, then it is better you stop the services first).