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

MOSC Banner

After applying Patch 9654468 R12.POS.B the object POS_SUPP_CONTACT_PKG has become invalid

edited Feb 1, 2013 6:07AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 1 commentAnswered ✓

 Hi,


Issue: After applying Patch 9654468 R12.POS.B the object  POS_SUPP_CONTACT_PKG  has become invalid

SQL> alter package POS_SUPP_CONTACT_PKG compile body;

Warning: Package Body altered with compilation errors.

SQL> show error;
Errors for PACKAGE BODY POS_SUPP_CONTACT_PKG:

LINE/COL ERROR
-------- -----------------------------------------------------------------
321/4    PL/SQL: Statement ignored
321/29   PLS-00302: component 'UPDATE_PARTY_ALT_PHONE' must be declared
348/4    PL/SQL: Statement ignored
348/29   PLS-00302: component 'UPDATE_PARTY_URL' must be declared
776/5    PL/SQL: Statement ignored
776/30   PLS-00302: component 'UPDATE_PARTY_ALT_PHONE' must be declared
795/5    PL/SQL: Statement ignored
795/30   PLS-00302: component 'UPDATE_PARTY_URL' must be declared




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