How to Check & Compile invalid objects in R12.2.x



@ Invalid Object Count Query for Apps User
SELECT COUNT(*)
FROM DBA_OBJECTS
WHERE STATUS = 'INVALID';

@ Detail Query for Invalid Object for Apps User
SELECT OWNER, OBJECT_TYPE, COUNT(*)
FROM DBA_OBJECTS
WHERE STATUS = 'INVALID'
GROUP BY OWNER, OBJECT_TYPE;



@ Invalid object compile From Database Tier:
  1.  Login Database Tier
  2. Environment Sourcing (SID_Hostname.env)
  3.   cd $ORACLE_HOME/rdbms/admin
  4. sqlplus / as sysdba
  5.  SQL> @utlrp.sql

@ Invalid object compile From Application Tier:
  1.  Login Application Tier
  2. Environment Sourcing
  3. adadmin
  4. Option 3: compile/reload Application Database Entities Menu
  5.  Option 1: Compile Apps Schema


Post a Comment

0 Comments

3