My Oracle Support Banner

R12: AP: Bank Errors Calculation Not Matching Payables Accounting (Doc ID 2280398.1)

Last updated on JANUARY 03, 2023

Applies to:

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

Symptoms

On : 12.1.3 version, Reconciliation and Clearing


Bank Errors calculated during Reconciliation not matching AP Payment Accounting.

 

Example:


Functional currency: AED
Payment Amount 6311.03 EGP / 2610.43 AED

Exchange Rate: 0.41363
Cleared amount in Cash Management: 1473.44
Errors entered in Cash Management: -1136.99

 

Actual payment accounting:

                                    Debit         Credit
Bank Errors                                    2014.36
Cash                                             596.07
Cash Clearing               2610.43

 


Expected payment Accounting:

                                 Debit              Credit
Bank Errors                                       1136.99 -> this line should be in accordance with the Bank Errors entered in Cash Management
Cash                                               1473.44
Cash Clearing             2610.43




The issue can be reproduced at will with the following steps:
1. Reconcile a check and enter bank errors
2. Account the check
3. Verify that the bank errors and cash accounting are incorrect



Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.