Recompilation of APPS (E-Business) Objects

Objective: To recompile or validate APPS (E-Business) objects that are invalid.

Applies to Oracle E-Business Suite (11i or R12).

Case: Recompilation of APPS schema is done through AD Admin Utility during Oracle APPS upgrade or migration process or when custom packages are used in APPS schema or when any object becomes invalid.

Steps:

1. Recompile the APPS schema through adadmin

2. Clear the cache

3. Bounce the Apache server

4. Re-try the process

5. Run the following Queries to check on invalids if any:

For Example: APPS  is the Schema name and AP is the Module name.

SELECT owner,object_type,object_name, status
FROM DBA_OBJECTS
WHERE status='INVALID'
and owner in ('APPS', 'AP')
group by owner,object_name,object_type, status;

SELECT owner,object_type,object_name, status
FROM DBA_OBJECTS
WHERE status='INVALID'
order by 3,2;