INVALID OBJECTS IN R12

http://onlineappsdba.com/index.php/2010/06/03/how-to-compile-apps-schema-invalid-objects-in-r12/

https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&doctype=HOWTO&id=314538.1

http://myappsdba.com/how-to-compile-apps-forms-library-modules-or-pll-files-in-11i-applications/


1. How many invalid objects are in the Database ?


select owner,object_type,COUNT(*)
from dba_objects
where owner = 'APPS'
and status = 'INVALID'"
from dba_objects
where status='INVALID'
group by owner, object_type;


select object_name,object_type,owner
from dba_objects
where owner = 'APPS'
and status = 'INVALID'


2. Check for details about the invalid objects :

column owner format A9
column object_name format A31
column object_type format A15
column last_ddl_time format A10
spool invalids.lst
select OWNER, OBJECT_NAME,OBJECT_TYPE,LAST_DDL_TIME
from dba_objects where status='INVALID'
order by owner;



Validating invalid objects

invalid objects in the E-Business Suite Environment 11i and 12.mht

Compile_Objects_apps_schema_files.mht Using adadmin

Recomplie_FORM_LIB_PLL_Using_Adadmin.mht Using adadmin