My Oracle Support Banner

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.

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

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
Symptoms
Cause
Solution
 BackGround:
 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) 
 1. The most used being by Payment Number or Check Number. This Number is likely to appear on your Bank Statement and will be available for the Payment.
2. In the case of Printed Documents this is the Paper Document Number
  (IBY_PAYMENTS_ALL.paper_document_number) and the Payment Number
(AP_CHECKS_ALL.check_number)
  - the one allocated from the sequence of numbers configured in Cash Management - Bank Accounts - Manage Payment Documents.
In this case the Payment Reference Number
  (IBY_PAYMENTS_ALL.payment_reference_number) is generated by the application,
but because a Paper Document Number also exists, it is that that is used for the Check Number. 
 R12: How to control the Document Numbers assigned to Electronic/Wire Payments <Note:855097.1>
 Usually Electronic Payments are for more than one Payment, are processed as a batch and only one line appears on the Bank Statement to reconcile all of the Payments against. In such a case you will need to provide a reference to your bank that they will use in the Check Number position of the Bank Statement - this is the Payment Instruction ID. The Reference for the Payment Instruction that ultimately lead to  the Output file.
NOTE: It is not the PPR Name because One PPR Can, under certain circumstances, result in Multiple Payment Instructions.
 If the bank should enter each Payment from a batch individually on the Bank Statement and they use the payment_reference_number as the Payment Number on the Bank Statement, then this will match with the Check Number for  Autoreconciliation when no Paper Document Exists.
Please note:
If Bank give each payment level line detail then: Number column to have:
PAPER_DOCUMENT_NUMBER with respective amount.
This number you need to include it in the Payment File Sent to your bank.

Since customer did not do this initially hence this datafix request.
References


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.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.