Invalids after applying the patch (14493264,13857555)
Hi,
Issue:
we got extra new invalids after applying the patch (14493264,13857555) we tried compiling manually, but of no luck.
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:
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:
Tagged:
0