How to Compile Apps Schema

This option is used to compile invalid objects in the apps schema(s). Invalid objects are those who have missing definition in the database or can be caused by applying a patch.

To get a listing of invalid objects->

select count(*) from dba_objects where status='INVALID';

To Compile invalid objects->Run adadmin>Goto Compile/Reload Applications Database Entities>compile apps schema

It actually calls adcompsc.pls

To compile the invalid objects in database without using adadmin-run either of these >@$ORACLE_HOME/rdbms/admin/utlrp.sql as sysdba OR

$ORACLE_HOME/rdbms/admin/utlrcmp.sql as sysdba

Also you can compile the objects manually->

alter view <name> compile; (compile view)

alter package<name> compile; (package specification)

alter package<name> compile body; (package body)