R12/CE: Invalid Objects CLL_F035_CPY_TRX_COD_XML, CLL_F035_SEND_CASH_PKG and CLL_F035_STATEMENT_LOAD_PKG with "PL/SQL: ORA-00904: "BANK_ACCT_CURRENCY_CODE": invalid identifier"

(Doc ID 2178028.1)

Last updated on OCTOBER 13, 2017

Applies to:

Oracle Cash Management - Version 12.1.3 to 12.2.5 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

After applying some Brazilian CLL patches the following are now invalid objects:

CLL_F035_CPY_TRX_COD_XML
CLL_F035_SEND_CASH_PKG
CLL_F035_STATEMENT_LOAD_PKG

ERROR
-----------------------
1. Errors for PACKAGE BODY CLL_F035_CPY_TRX_COD_XML:
LINE/COL ERROR
-------- -----------------------------------------------------------------
347/9 PL/SQL: SQL Statement ignored
380/17 PL/SQL: ORA-00904: "SUB_FAMILY_CODE": invalid identifier
500/13 PL/SQL: Statement ignored
666/37 PLS-00364: loop index variable 'SRC_TRX_CODE' use is invalid
666/50 PL/SQL: ORA-00984: column not allowed here.

2. Errors for PACKAGE BODY CLL_F035_SEND_CASH_PKG:
LINE/COL ERROR
-------- -----------------------------------------------------------------
643/14 PL/SQL: SQL Statement ignored
661/40 PL/SQL: ORA-00904: "BANK_ACCT_CURRENCY_CODE": invalid identifier

3. Errors for PACKAGE BODY CLL_F035_STATEMENT_LOAD_PKG:
LINE/COL ERROR
-------- -----------------------------------------------------------------
1049/29 PL/SQL: SQL Statement ignored
1066/36 PL/SQL: ORA-00904: "BANK_ACCT_CURRENCY_CODE": invalid identifier



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