R12: CE: Bank Statement Import Process Errors for R12.1.1 and R12.1.2 (Doc ID 1294366.1)

Last updated on OCTOBER 13, 2014

Applies to:

Oracle Cash Management - Version 12.0.0 to 12.2.4 [Release 12 to 12.2]
Information in this document applies to any platform.

Symptoms

Issue 1: Bank Account not loaded into Treasury:

You upgraded from: R12.1.1 to R12.1.2

R12.1.1: When you Import a bank statement which is dated on or after the System Date the statement will not Import. Error as:

 

Issue 2: Bank Statement Header shows correct balance:

Our Assumption of the Bank account Balance is as per the Bank statement showing in the Bank Statement Reconciliation Form:
CONTROL_BEGIN_BALANCE
CONTROL_END_BALANCE

However, the error in R12.1.2 talks about the bank account balances in Treasury?
This will mean that the Balances are not updated, which is the case you find, however, statement in Bank statement Reconciliation form showing the latest balance.
This is adding new confusion, when you see the Cash Position and Forecast?

 

Issue 3:Bank statement Import Fails When two bank statements with same date but with with different balances are imported, Error
Some of the bank account balances reported on the statements for this bank account were not equal to
previously entered account balances. The previously entered account balances were retained but may be
manually updated with the balances reported on the statements.

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