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

MOSC Banner

Invalids after applying the patch (14493264,13857555)

edited Mar 29, 2013 8:58PM in Install, Upgrade, Clone, Patch - EBS (MOSC) 1 commentAnswered ✓
 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:
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