Autoreconcile ELECTRONIC PAYMENTS / ACH Fails where PAPER_DOCUMENT_NUMBER generated After R12.1.3 Upgrade
Last updated on MARCH 08, 2017
Applies to:Oracle Cash Management - Version 12.1.3 to 12.2 [Release 12.1 to 12.2]
Oracle Payables - Version 12.1.3 to 12.2 [Release 12.1 to 12.2]
Information in this document applies to any platform.
On : 12.1.3 version, Reconciliation and Clearing
When attempting to Autoreconcile an ELECTRONIC PAYMENTS where PAPER_DOCUMENT_NUMBER generated
the following error occurs.
The statement already exists.
No matching payment for the invoice number and the agent name
No matching payment
1). Create an Invoice
2). Create a Format and assign Payment Document to the format
3). Create an Electronic Processing Payment Process Profile (PPP) Using the Format Create above
4). Submit a PPR Supplying Payment Document Created and PPP
5). Paper Document Number should be generated for payment
6). This number you need to include it in the Payment File Sent to your bank but by nistake you still have:IBY_Payments_All.PAYMENT_REFERENCE_NUMBER
Now try to Reconcile Bank Statement when the Statement lines comes with IBY_Payments_All.PAYMENT_REFERENCE_NUMBER
The issue has the following business impact:
Due to this issue, users cannot AUTORECONCILE
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