{"id":1843,"date":"2010-06-03T18:16:23","date_gmt":"2010-06-03T22:16:23","guid":{"rendered":"http:\/\/onlineappsdba.com\/index.php\/2010\/06\/03\/how-to-compile-apps-schema-invalid-objects-in-r12\/"},"modified":"2017-04-12T07:38:01","modified_gmt":"2017-04-12T11:38:01","slug":"how-to-compile-apps-schema-invalid-objects-in-r12","status":"publish","type":"post","link":"https:\/\/onlineappsdba.com\/index.php\/2010\/06\/03\/how-to-compile-apps-schema-invalid-objects-in-r12\/","title":{"rendered":"How to compile Apps Schema (invalid objects) in R12 ?"},"content":{"rendered":"

Quick tip on how to compile apps schema (or invalid objects in database) in Oracle applications R12<\/p>\n

You can compile invalid objects (or Apps Schema) using below three methods (compiling invalid is not limited to these three methods<\/span>)<\/p>\n

1. From Database Tier
\n<\/strong>a) Login as database tier user (ovisr12 in my case)
\nb) Set environment variable (under $INSTALL_DIR\/db\/tech_st\/[10.2.0 or 11.1.0]\/[sid]_[hostname].env)
\nc) cd $ORACLE_HOME\/rdbms\/admin
\nd) sqlplus “\/as sysdba”
\ne) SQL> @utlrp.sql<\/strong><\/p>\n

\"\"<\/a><\/p>\n

.<\/p>\n

.<\/p>\n

.<\/p>\n

2. From application tier (using adadmin)<\/strong>
\na) Login as application tier user (avisr12 in my case)
\nb) Set environment variable (under $INSTALL_DIR\/apps\/apps_st\/appl\/APPS[sid]_[hostname].env)
\nc) admin
\nd) option 3 “compile\/reload Applications Database Entities menu
\ne) option 1 “Compile Apps Schema”<\/p>\n

.<\/p>\n

\"\"<\/a><\/p>\n

\"\"<\/a><\/p>\n

\"\"<\/a><\/p>\n

.<\/p>\n

.<\/p>\n

.<\/p>\n

3. From SQL (Individual objects)
\n<\/strong>a) Identity Invalid Object “SQL> select object_name, owner, object_type from all_objects where status like ‘INVALID’ ”
\nb) SQL> alter [object] [object_name] compile;<\/p>\n

.<\/p>\n

\"\"<\/a>
\n.<\/p>\n

Related<\/span><\/strong><\/p>\n