My Oracle Support Banner

R12: CE: Unable to Reconcile Foreign Currency Payments Due to Amount Mismatch (Doc ID 2903628.1)

Last updated on AUGUST 28, 2023

Applies to:

Oracle Cash Management - Version 12.1.3 and later
Information in this document applies to any platform.


Payment currency is EUR and payment made via bank account having USD currency

When payment was made exchange rate picked as defined in system but while bank clearing the payment and sending statement it is using different exchange rate and mismatch in amount.

When running the Autoreconciliation program log file shows the following occurs for many transactions the following error occurs:

No Matching payment group
No matching journal entries
No Matching payment batch
Statement line amount is not within the tolerance range

The issue can be reproduced at will with the following steps:
1. (N) Cash Mnagement>View>Other>Submit new requests
2. Submit Autoreconciliation
3. Check for program log file




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

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