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.

6 docs every apps dba must read

 

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

About the Author Atul Kumar

Oracle ACE, Author, Speaker and Founder of K21 Technologies & K21 Academy : Specialising in Design, Implement, and Trainings.

follow me on:

Leave a Comment:

8 comments
Kanti says June 7, 2010

sqlplus / as sysdba
@?/rdbms/admin/utlrp.sql

This is what i usually use.

Reply
suresh says March 10, 2011

hi,

if i compile manually also getting error, for that how do i resolve…

thanks
suresh

Reply
Atul Kumar says March 10, 2011

@ Suresh,
Run “show error” to see cause of compilation issue and fix it and then compile again

Reply
kirthikanth says June 2, 2011

i am not able to view the metalink noted for invalids

Reply
Atul Kumar says June 3, 2011

@ kirthikanth,
Thanks for highlighting this. Link updated with correct metalink ID

Reply
» Compiling Forms in Oracle Apps R12 : APP-WSH-231210 ORA-04062 WSH_DELIVERY_DETAILS_INV Online Apps DBA: One Stop Shop for Apps DBA’s says May 8, 2012

[…] at error message it is clear that fix is to compile invalid database objects and recompile form. Fix is well explained in My Oracle Support Note # 1315451.1 Shipping […]

Reply
Pradeep says July 30, 2015

Hi Atul,

I tried all these steps in my production server. It worked fine and compiled many objects.

However, still there several objects which could not be compiled. While compiling we got warning and errors.

SQL> alter PROCEDURE APPS.F COMPILE;

Warning: Procedure altered with compilation errors.

SQL> Warning: Procedure altered with compilation errors.

Please help

Pradeep

Reply
    Atul Kumar says July 30, 2015

    @Pradeep, Run show error on SQL prompt to see warnings in compilation, based on error we can suggest .

    Reply
Add Your Reply

Not found