Invalid objects after applying the patch 14493264 and 13857555 (R12.1.3)
Hi,
Issue:
Invalid objects after applying the patch 14493264 and 13857555.
SQL>select object_name,object_type,owner from dba_objects a
where status = 'INVALID'
and not e
(select 0 from SR_3_33M1DQX_ b where b.object_name=a.object_name and b.owner=a.owner);
OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE OWNER
------------------- ------------------------------
AP_APXHRUPD_XMLP_PKG
PACKAGE BODY APPS
ITG_SYNCSUPPLIERINBOUND_PVT
PACKAGE BODY APPS
SQL> alter package AP_APXHRUPD_XMLP_PKG compile body;
Warning: Package Body altered with compilation errors.
SQL> sho error
Errors for PACKAGE BODY AP_APXHRUPD_XMLP_PKG:
LINE/COL ERROR
-------- -----------------------------------------------------------------
158/7 PL/SQL: Statement ignored
where status = 'INVALID'
and not e
(select 0 from SR_3_33M1DQX_ b where b.object_name=a.object_name and b.owner=a.owner);
OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE OWNER
------------------- ------------------------------
AP_APXHRUPD_XMLP_PKG
PACKAGE BODY APPS
ITG_SYNCSUPPLIERINBOUND_PVT
PACKAGE BODY APPS
SQL> alter package AP_APXHRUPD_XMLP_PKG compile body;
Warning: Package Body altered with compilation errors.
SQL> sho error
Errors for PACKAGE BODY AP_APXHRUPD_XMLP_PKG:
LINE/COL ERROR
-------- -----------------------------------------------------------------
158/7 PL/SQL: Statement ignored
Tagged:
0