In-Oracle.com  -> Oracle Applications (apps)  -> 11i

-> Compile / Reload Database Entities in Oracle 11i

 Compile / Reload Database Entities in Oracle 11i

1. Access "Compile/ Reload Applications Database Entities" menu

2. Compile/ Reload Applications Database Entities menu options   (on Administration Server node only)

3. Compile APPS schema

4. Compile menu information

5. Compile flexfields

6. Reload JAR files to database

1. Access "Compile/ Reload Applications Database Entities" menu

Run adadmin and choose the option "3. Compile/Reload Applications Database Entities menu".

2. Compile/ Reload Applications Database Entities menu options

Compile/Reload Applications Database Entities
---------------------------------------------------

1. Compile APPS schema

2. Compile menu information

3. Compile flexfields

4. Reload JAR files to database

5. Return to Main Menu


Enter your choice [5] :

3. Compile APPS schema

This must be done when there are invalid objects in APPS schema. 

AutoPatch compiles invalid objects automatically after applying a patch. 

Run Invoker Rights processing in incremental mode: OPTIONS:

YES  => Run Invoker's rights processing only on packages that have changed since the last run

NO   => All the objects will be compiled.

Example:

Enter your choice [5] : 1

AD utilities can support a maximum of 999 workers. Your
current database configuration supports a maximum of 91 workers.
Oracle recommends that you use between 4 and 8 workers.

Enter the number of workers [4] :
 

Run Invoker Rights processing in incremental mode [No] ? Yes

Creating FND_INSTALL_PROCESSES table...
Spawned Process 28617

Setting parallel context: Invoker's Rights processing at R115

(...)

Review the messages above, then press [Return] to continue.

4. Compile menu information

This must be run:

• after uploading menu entries

• Compile Security concurrent request fail after changing the menu entries

Example:

Enter your choice [5] : 2

Do you wish to force compilation of all menus? [No] ?     ( Yes = will force the generation of all menus: in general is not needed )

Generating any out of date menus.

sqlplus -s APPS/***** @/APPS/visappl/fnd/11.5.0/sql/fndscmpi.sql
Spawned Process 28910

Review the messages above, then press [Return] to continue.

5. Compile flexfields

This must be run if a patch specifies this. The flexfields automatically compiles the first time they are accessed. 

Example:

Enter your choice [5] : 3

Deleting existing compiled flexfield information.

Compiling all application flexfields.

/APPS/visappl/fnd/11.5.0/bin/fdfcmp APPS/***** 0 Y
Spawned Process 28924

Done.

Review the messages above, then press [Return] to continue.

6. Reload JAR files to database

This task runs the loadjava utility to reload all APPS JAR files into the database. This could be necessary if some Java classes have been removed from the database (database becomes corrupt and JVM is reloaded).

In-Oracle.com  -> Oracle Applications (apps)  -> 11i

-> Compile / Reload Database Entities in Oracle 11i