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

MOSC Banner

Patches 6402032 and 6281689 - Causes Package AR_PREPAYMENTS_PUB to be Invalid

edited Sep 1, 2012 12:52AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 9 commentsAnswered ✓
VPC Team member opened this thread for the customer.
After applying patches 6402032 and 6281689 the following package body became invalid.

OBJECT_NAME                                   OWNER                          OBJECT_TYPE
--------------------------------------------- ------------------------------ -------------------
AR_PREPAYMENTS_PUB                            APPS                           PACKAGE BODY

SQL>
SQL> alter package AR_PREPAYMENTS_PUB compile body;

Warning: Package Body altered with compilation errors.

SQL> show error
Errors for PACKAGE BODY AR_PREPAYMENTS_PUB:

LINE/COL ERROR
-------- -----------------------------------------------------------------
70/11    PLS-00323: subprogram or cursor 'CREATE_PREPAYMENT' is declared in a package specification and must be defined in the package body

168/12   PLS-00323: subprogram or cursor 'GET_INSTALLMENT' is declared in a package specification and must be defined in the package body
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