Autoreconcile ELECTRONIC PAYMENTS / ACH Fails where PAPER_DOCUMENT_NUMBER generated After R12.1.3 Upgrade
(Doc ID 1470517.1)
Last updated on AUGUST 13, 2018
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
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
|Automatic Reconciliation can be done in a number of ways. (For Single Payments, the User Guide informs us Matching is by Payment Number, Invoice Number and Supplier Bank Account or Invoice Number and Supplier Name)|
|R12: How to control the Document Numbers assigned to Electronic/Wire Payments <Note:855097.1>|
|This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.|