R12/CE: Autoreconciliation Errors For Cashflows Created Using Bank Account Transfer and Bank Reference Number as - Statement Line Is Not Within Tolerance Range
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.
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.
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.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms