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.

Symptoms

On : 12.1.3 version, Reconciliation and Clearing

When attempting to Autoreconcile an ELECTRONIC PAYMENTS where PAPER_DOCUMENT_NUMBER generated
the following error occurs.

ERROR
-----------------------
The statement already exists.
Recon line:
No matching payment for the invoice number and the agent name
No matching payment

Steps:
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

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot AUTORECONCILE

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