Many invalids in APPS and MSCAPPS schema after upgrade to R12.1.3

Hi Santosh,

Welcome to Patching community !!!

Issue:

Many invalid objects in our VISION instance after upgrade from R12.1.1 to R12.1.3

I have tried compiling them using UTLRP.sql and Manually still they are not getting compiled.

So please help us in compiling these invalids asap as our functional team is waiting for this instance to start their work.

SQL> alter package ADS_AUDIT_PROFILE_OPTIONS compile body;

Warning: Package Body altered with compilation errors.

SQL> show error
Errors for PACKAGE BODY ADS_AUDIT_PROFILE_OPTIONS:

LINE/COL ERROR
-------- -----------------------------------------------------------------
61/5     PL/SQL: SQL Statement ignored
61/17    PL/SQL: ORA-00942: table or view does not exist