R12: Bank Errors Calculation Not Matching Payables Accounting

(Doc ID 2280398.1)

Last updated on JULY 03, 2017

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

ACTUAL BEHAVIOR
---------------
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 BEHAVIOR
-----------------------
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



STEPS
-----------------------
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



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