PON_AUCTION_APPROVAL_PKG and PON_EMD_AR_INTEGRATION_GRP Invalid After Applying Patch 9772533 (Doc ID 1306414.1)

Last updated on DECEMBER 07, 2016

Applies to:

Oracle Sourcing - Version 12.1.1 to 12.1.1 [Release 12.1]
Information in this document applies to any platform.

Symptoms

In Oracle Sourcing, Release 12.1.1, the package bodies PON_AUCTION_APPROVAL_PKG and PON_EMD_AR_INTEGRATION_GRP are invalid after application of Patch 9772533.

Errors for PACKAGE BODY PON_AUCTION_APPROVAL_PKG:

LINE/COL ERROR
-------- -----------------------------------------------------------------
893/1 PLS-00103: Encountered the symbol "" when expecting one of the
following:
begin case declare end exit for goto if loop mod null pragma
raise return select update while with <an identifier>
<a double-quoted delimited-identifier> <a bind variable> <<
close current delete fetch lock insert open rollback
savepoint set sql execute commit forall merge pipe
The symbol "" was ignored.


Errors for PACKAGE BODY PON_EMD_AR_INTEGRATION_GRP:

LINE/COL ERROR
-------- -----------------------------------------------------------------
1278/5 PL/SQL: Statement ignored
1278/59 PLS-00357: Table,View Or Sequence reference
'HZ_ACCOUNT_NUM_S.NEXTVAL' not allowed in this context

4024/3 PL/SQL: Statement ignored
4024/3 PLS-00306: wrong number or types of arguments in call to
'CREATE_CARD'

5519/29 PL/SQL: Item ignored
5519/49 PLS-00302: component 'NAME' must be declared
5578/5 PL/SQL: SQL Statement ignored
5580/12 PLS-00320: the declaration of the type of this expression is
incomplete or malformed

5582/7 PL/SQL: ORA-00904: : invalid identifier
5618/3 PL/SQL: Statement ignored
5618/50 PLS-00357: Table,View Or Sequence reference
'RA_CUSTOMER_TRX_LINES_S.NEXTVAL' not allowed in this context

5636/5 PL/SQL: SQL Statement ignored
5673/27 PL/SQL: ORA-00904: "L_MEMO_NAME": invalid identifier
5673/27 PLS-00320: the declaration of the type of this expression is
incomplete or malformed



Steps to Reproduce

The issue can be reproduced at will by applying the following patches to a Release 12.1.1 environment:
1. <Patch 10327656>. This patch then causes package body POS_VENDOR_REG_PKG to be invalid.
2. <Patch 9772533>. This patch is applied to resolve the compilation errors for POS_VENDOR_REG_PKG; however, this patch then causes the two package bodies above to be invalid.



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms