Autoreconcile ELECTRONIC PAYMENTS / ACH Fails where PAPER_DOCUMENT_NUMBER generated After R12.1.3 Upgrade

(Doc ID 1470517.1)

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.
Recon line:
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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms