R12.1.3 After applying PA_DATAFIXES_UTIL package was invalid.
Hi,
We were applying patch 12429587 as a result of the oracle recommended patches exercise. Patch 12730285 was listed as a pre req patch.
Patch 12730285 was superceeded by 13833481. As advised in patch readme's we applied 13833481. After applying PA_DATAFIXES_UTIL package was invalid.
o2cdba SQL> alter package APPS."PA_DATAFIXES_UTIL" COMPILE body;
Warning: Package Body altered with compilation errors.
o2cdba SQL> show errors
Errors for PACKAGE BODY APPS."PA_DATAFIXES_UTIL":
LINE/COL ERROR
-------- -----------------------------------------------------------------
655/1 PL/SQL: SQL Statement ignored
656/6 PL/SQL: ORA-00942: table or view does not exist
674/1 PL/SQL: SQL Statement ignored
680/67 PL/SQL: ORA-00942: table or view does not exist