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

MOSC Banner

After applying the patch 15966842 new invalids got generated : AHL_UTIL_UC_PKG and EDW_SUPPLIER_ITE

edited Mar 19, 2013 5:29AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 2 commentsAnswered

 Hi,

After applying the patch 15966842

new invalids generated and after compile we got this error

SQL> alter package apps.AHL_UTIL_UC_PKG compile body;

Warning: Package Body altered with compilation errors.

SQL> show errors
Errors for PACKAGE BODY APPS.AHL_UTIL_UC_PKG:

LINE/COL ERROR
-------- -----------------------------------------------------------------
34/1 PLS-00452: Subprogram 'GETCSI_LOCATIONDESC' violates its
associated pragma

SQL> alter package apps.EDW_SUPPLIER_ITEM_PKG compile body;

Warning: Package Body altered with compilation errors.

SQL> show errors
Errors for PACKAGE BODY APPS.EDW_SUPPLIER_ITEM_PKG:

LINE/COL ERROR
-------- -----------------------------------------------------------------
14/3 PLS-00452: Subprogram 'SUPPLIER_ITEM_FK' violates its associated
pragma
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