R12/CE: Autoreconciliation Errors For Cashflows Created Using Bank Account Transfer and Bank Reference Number as - Statement Line Is Not Within Tolerance Range (Doc ID 2240783.1)

Last updated on MARCH 06, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Reconciliation and Clearing

When run AutoReconciliation for CashFlows Created by Bank Account Transfer where Bank Reference Number is "AUTO" for all such BAT, Not able to autoreconcile BAT cashflows with the statement line having bank_trx_number as "AUTO", transaction date but different amounts.

the following error occurs.

ERROR  Statement line amount is not within the tolerance.

Note:
Auto Reconciliation Execution Report is showing that Sweep Lines cannot be reconciled automatically with cash flows due to Statement Line is not within Tolerance Range.
However, the statement line amount and the cash flow amount are exactly the same. Therefore no tolerance should be taken into scope.

The Bank Account currency is EUR.
The Bank Account Transfer was created in EUR.
The Bank Statement is in EUR.
The Ledger Functional Currency is GBP.

Workaround:
It's possible to manually reconcile these lines, however not feasible as a permanent solution.
The business requires for this to be automated with the Auto Reconciliation program.

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