adadmin Maintain Applications Database Entities in fusion applications

Adadmin Maintain Applications Database Entities[Fusion applications]

Through the adadmin maintain applications  Database entities  we are able to manage the  objects or data related to Oracle Fusion Applications.we can check the status of the objects or entities which is related to the fusion applications in the database   as a regular maintenance procedure, and we can compile and provide the health check and regnant the fusion application schema roles and responsibilities

            AD Administration Main Menu

   --------------------------------------------------

   1.    Maintain snapshot information

   2.    Maintain Applications Database Entities menu

   3.    Exit AD Administration

  

select the menu 2 for database related maintenance activities

Compiling the invalid objects in the Fusion applications database

Enter your choice [3] : 2

         Maintain Applications Database Entities

   ---------------------------------------------------

   1.    Compile Invalid Objects

   2.    Health Check

   3.    Re-create grants for FUSION schema

   4.    Maintain multi-lingual tables

   5.    Return to Main Menu

After entering  you choice you will able to find the 5 menus regarding the applications database entities

Enter your choice [5] : 1

sqlplus -s /nolog @/u01/oracle/fa/products/fusionapps/applications/lcm/ad/db/sql/adutlrcmp.sql ***** ***** 0 ALL

Getting list of invalid objects in FUSION schema.

sqlplus -s /nolog @/u01/oracle/fa/products/fusionapps/applications/lcm/ad/db/sql/adallinvobj.sql ***** ***** /u01/oracle/fa/products/fusionapps/applications/admin/FUSION/log/adtest_prepatch_invalidobjects

Invalid object reports are recorded in

/u01/oracle/fa/products/fusionapps/applications/admin/FUSION/log/adtest_prepatch_invalidobjects.*

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

It will compile all the invalid objects and if some of the objects are not compiled you can find the name of the object in the report file 

Running the health check by using the adadmin

         Maintain Applications Database Entities

   ---------------------------------------------------

   1.    Compile Invalid Objects

   2.    Health Check

   3.    Re-create grants for FUSION schema

   4.    Maintain multi-lingual tables

   5.    Return to Main Menu

Enter your choice [5] : 2

sqlplus -s /nolog @/u01/oracle/fa/products/fusionapps/applications/lcm/ad/db/sql/adhlcheck.sql /u01/oracle/fa/products/fusionapps/applications/admin/FUSION/log ALL FUSION fusion_dynamic

The following file has been generated in /u01/oracle/fa/products/fusionapps/applications/admin/FUSION/log:

        - ad_health_check_report.html.

Successful completion of the SQL scripts above does not

guarantee that any or all of your FUSION schemas are correct.

You must review the output from this validation step and fix

all indicated problems.  You should then re-run this step to

ensure that all problems have been corrected.

Check the health check report and fix the issue in the fusion database 

Re-create grants for FUSION schema using Ad admin

   1.    Compile Invalid Objects

   2.    Health Check

   3.    Re-create grants for FUSION schema

   4.    Maintain multi-lingual tables

   5.    Return to Main Menu

Enter your choice [5] : 3

Processing FUSION objects and roles.

sqlplus -s /nolog @/u01/oracle/fa/products/fusionapps/applications/lcm/ad/db/sql/adsodgts.sql

Processed FUSION objects and roles.

It will re-grant all the privileges   to the fusion schema [same like apps schema in the EBS]