How to compile apps schema in Oracle applications R12

How to compile apps schema (or invalid objects in database) in Oracle applications R12

1.       Connect to Database Tier

[ora@sujeet ~]$ cd $ORACLE_HOME/rdbms/admin

[ora@sujeet admin]$ sqlplus / as sysdba

Find how many Invalid objects. (Here 182 row select).

SQL> select object_name, owner, object_type from all_objects where status= 'INVALID';

182 rows selected.

Run below scripts:-

SQL> @utlrp.sql

Again check Invalid objects. (Here 0 row select).

SQL> select object_name, owner, object_type from all_objects where status= 'INVALID';

no rows selected

2. From application tier (using adadmin)
a) Login as application tier user.
b) Set environment variable.
c) Run “adadmin”
d) option 3 “compile/reload Applications Database Entities menu
e) option 1 “Compile Apps Schema”

3. From SQL (Individual objects)
a) Identity Invalid Object

SQL> select object_name, owner, object_type from all_objects where status= 'INVALID';
b) SQL> alter [object] [object_name] compile;