My Oracle Support Banner

R12/CE: Autoreconciliation, Reconciliation Cross-Functional Currency, Foreign Currency including BAT, Sweep, CashFlows (Doc ID 1326108.1)

Last updated on JULY 10, 2020

Applies to:

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

Goal

Please give details for Reconciliation of a Bank Account scenario: Foreign, International and Exchange Rate Gain / Loss and Accounting?

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
  
 (1). Basics:
 (2). Specific Scenarios
 1. Foreign Currency Bank Account Functional Clarification
 2. Multi-Currency Handling
 3. Exchange rate gains and losses
 4. Basic Reconciliation Principles
 5.  Exchange Rate Gains and Loss Accounting
 6.Recalculate Functionality
 (3). Foreign Bank Account Reconciliation Errors
 a). Missing exchange rate information
 b). Exchange rate type missing
 c). Undefined exchange rate
 d). Exchange rate date missing
 e). Miscellaneous receipt currency doesn't match bank currency
 f). You must complete Currency Exchange Information
 g). Statement Line Amount Is Not Within The Tolerance Range
 (4). Error Message and summary actions:
 (5). Issue / Resolutions:
 1). While unclearing a cashflow transaction, the account currency amount cleared was incorrect. The exchange informatin was also getting changed in the available transaction screen
 2). When you run the AutoReconciliation for the bank Account Transfers in US currency. It Error: Line amount functional currency not within the tolerance range
 3). When attempting to Auto-reconciliation does not match bank statement lines with AP transactions even when reference number matches. This only seems to happen when the bank account currency is different than the ledger currency
 4). For a non-functional currency bank account (account currency differs from ledger currency), if the bank statement lines are auto reconciled for Bank Generated Sweep Transactions in CE, then the Exchange rate and type are missing, due to which the create accounting program fails with the following error:
 95334 A conversion type is required when the entered  currency is different from the ledger currency.  Please enter a conversion type for line 1
 5). Issue:Line amount functional currency not within the tolerance range 
 6). Autoreconciliation tolerance checks in foreign currency scenarios
 (6). Accounting Example:
 (7). Latest Patches
 (8). Sql Investigation
 (9). Enhancements
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.