CLL_F035_CEXB: NEW FIELD IN CE_STATEMENT_LINES_INTERFACE.BANK_ACCT_CURRENCY_CODE, ARPLABIM - AutoReconciliation Import Errors This bank statement header contains no statement lines BRL to reconcile (Doc ID 2055633.1)

Last updated on MARCH 08, 2017

Applies to:

LAD Add-on Localizations - Version 12.1 to 12.2.3 [Release 12.1 to 12.2]
Oracle Cash Management - Version 12.1 to 12.2.4 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

On : 12.2.3 version, Brazil Consulting Localizations

ACTUAL BEHAVIOR
---------------
The Bank Statement Import using CE_AUTO_BANK_IMPORT.pck imports only headers and not lines. You have identified that the column "bank_acct_currency_code" from table "ce_statement_lines_interface" comes with default values “USD”.
When you execute the concurrent Bank Statement Import and data are inputted in the table CE_STATEMENT_LINES_INTERFACE the field BANK_ACCT_CURRENCY_CODE is being populated with default value ‘USD’, when the expected is value be ‘RON’ or other.  The value ‘USD’ default in the field BANK_ACCT_CURRENCY_CODE is because of table CE_STATEMENT_LINES_INTERFACE’s property, as you can see below:
bank_acct_currency_code VARCHAR2(15 BYTE) DEFAULT 'USD' NOT NULL

This is causing the following impacts:
1 – The bank statement lines cannot be imported
2 - The screen (Bank Statement Lines Interface) doesn't show information.

  


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Load Bank Statement

2. Import Bank Statement

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot :

1 – The bank statement lines cannot be imported
2 - The screen (Bank Statement Lines Interface) doesn't show information.

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