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