Have Applied Patch 9301083:R12.AR.B But Makes The Following Packages Invalid (Doc ID 1275455.1)

Last updated on JULY 16, 2012

Applies to:

Oracle Receivables - Version 12.1.1 and later
Information in this document applies to any platform.
***Checked for relevance on 16-Jul-2012***

Symptoms

After applying patch 9301083:R12.AR.B, the following packages became invalid:

APPS.XLA_00222_AAD_S_000002_PKG
APPS.XLA_00222_AAD_S_000005_PKG
APPS.XLA_00222_AAD_C_000024_PKG

Error messages are:

PL/SQL: ORA-00904: "L4"."GAIN_LOSS_CCID": invalid identifier
PL/SQL: SQL Statement ignored
PLS-00302: component 'GAIN_LOSS_CCID' must be declared
PL/SQL: Item ignored
PL/SQL: ORA-00904: "L4"."GAIN_LOSS_CCID": invalid identifier
PL/SQL: SQL Statement ignored
PLS-00597: expression 'L_ARRAY_SOURCE_33' in the INTO list is of wrong type
PL/SQL: SQL Statement ignored
PLS-00306: wrong number or types of arguments in call to 'ACCTLINETYPE_126'
PL/SQL: Statement ignored
PLS-00364: loop index variable 'LINE_RECORD' use is invalid
PL/SQL: Statement ignored

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