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

MOSC Banner

Patch:16874034 and 16801219:Linux x86-64:12.1.3:resulted in the following invalid object AHL_UTIL_U

edited Jun 10, 2013 10:56PM in Install, Upgrade, Clone, Patch - EBS (MOSC) 3 commentsAnswered
 Hi,
After applying patches 16874034 & 16801219, we see the below two invalid package bodies which are giving errors while compiling


SQL> alter package AHL_UTIL_UC_PKG compile body;

Warning: Package Body altered with compilation errors.

SQL> show error
Errors for PACKAGE BODY AHL_UTIL_UC_PKG:

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





SQL> show error
Errors for PACKAGE BODY EDW_SUPPLIER_ITEM_PKG:

LINE/COL ERROR
-------- -----------------------------------------------------------------
14/3     PLS-00452: Subprogram 'SUPPLIER_ITEM_FK' violates its associated
         pragma


Thanks & Regards
phani bhaskar
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