Oracle   Home  

   Home  >  Oracle Applications 11i/ R12  >  Oracle Application 11i DBA  >  Maintain Applications Database Entities

1. Access "Maintain Applications Database Entities" menu

Run adadmin and choose the option "4. Maintain Applications Database Entities menu"

2. "Maintain Applications Database Entities" menu options

Enter your choice [6] : 4

Maintain Applications Database Entities
---------------------------------------------------

1. Validate APPS schema

2. Re-create grants and synonyms for APPS schema

3. Maintain multi-lingual tables

4. Check DUAL table

5. Maintain Multiple Reporting Currencies schema

6. Return to Main Menu

3. Validate APPS schema

This task creates a report called <APPS schema name>.lst in $APPL_TOP/admin/<SID>/out directory.

This report shows:

• invalid objects in APPS schema

• missing objects in APPS schema

This task must be run:

• when there are customizations in APPS schema;

• after upgrade, applying a maintenance pack;

• before convertion to Multi Org or Multi Reporting Currencies (MRC);

• after an import/ export;

• if an error is coming from AD_DDL package.

This task could be run also from the sqlplus (connected as system):

SQL> @$AD_TOP/admin/sql/advrfapp.sql <APPS schema name> <AOL schema name>

4. Re-create grants and synonyms for APPS schema

The APPS schema keeps the database code but, the tables are situated in each product schema. To access these tables, the code must have the right grants. So, this task re-grants the privileges,  recreates the synonyms for APPS schema (and also for APPLSYSPUB public schema).  

This task must be run:

• After a custom development 

• Failed Patches

• Incomplete import/ export

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