How to compile Apps Schema (invalid objects) in R12 ?
Quick tip on how to compile apps schema (or invalid objects in database) in Oracle applications R12
You can compile invalid objects (or Apps Schema) using below three methods (compiling invalid is not limited to these three methods)
1. From Database Tier
a) Login as database tier user (ovisr12 in my case)
b) Set environment variable (under $INSTALL_DIR/db/tech_st/[10.2.0 or 11.1.0]/[sid]_[hostname].env)
c) cd $ORACLE_HOME/rdbms/admin
d) sqlplus “/as sysdba”
e) SQL> @utlrp.sql
.
.
.
2. From application tier (using adadmin)
a) Login as application tier user (avisr12 in my case)
b) Set environment variable (under $INSTALL_DIR/apps/apps_st/appl/APPS[sid]_[hostname].env)
c) admin
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 like ‘INVALID’ ”
b) SQL> alter [object] [object_name] compile;
.
.
Related
Did you get a chance to download 6 Docs Every Apps DBA Must Read for EBS R12.2 ? If not, then get it now by clicking on link below.
If you need to learn more about Oracle Apps DBA (Architecture, Installation, WebLogic, Patching, Cloning and other maintenance tasks with the upgrade of Oracle E-Business Suite 12.2.0 to 12.2.4 then have a look at our Oracle Apps DBA Training