Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

Invalid objects after applying the patch 14493264 and 13857555 (R12.1.3)

edited Feb 4, 2013 1:41AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 2 commentsAnswered

 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
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center