Oracle   Home  

   Home  >  Oracle Applications 11i/ R12  >  Oracle Application 11i DBA  >  Compile/ Reload Applications Database Entities (adadmin)

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.

            More information about this subject ( Compile/ Reload Applications Database Entities (adadmin) ) you can get from  www.in-oracle.com