How to compile Apps Schema (invalid objects) in 11i and R12

You can compile invalid objects (or Apps Schema) using the following methods

I. Using Database Tier

-Login as database tier user

11i

Set environment variable (under $ORACLE_HOME/[SID]_[Hostname].env)
cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL>conn /as sysdba
SQL> @utlrp.sql

Release 12

Set environment variable (under $INSTALL_DIR/db/tech_st/RDMBS_Home/[SID]_[Hostname].env)
cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL>conn /as sysdba
SQL> @utlrp.sql

II. Using application tier (adadmin)

-Login as application tier user

11i

Set environment variable from $APPL_TOP/APPSORA.env)

adadmin
option 3 compile/reload Applications Database Entities menu
option 1 Compile Apps Schema”

Release 12

Set environment variable (under $INSTALL_DIR/apps/apps_st/appl/APPS[sid]_[hostname].env)

adadmin
option 3 compile/reload Applications Database Entities menu
option 1 Compile Apps Schema”

III. From SQL plus, this is individual objects only

-Figure out invalid Object in the database using

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