R12/CE: Payment Displays Multiple Times during Manual Clearing and on Transactions Available for Reconciliation Report (Doc ID 2061668.1)

Last updated on JUNE 11, 2024

Applies to:

Symptoms

On : 12.1.3 version, Reconciliation and Clearing

AP check appears in duplicate in the Cash Management Manual Clearing Form.

Check appears twice in the Cash Management Module under Bank Statements > Manual Clearing > Clear Transactions. The invoice this check is paying has an adjustment to add a $0 line and distributions to re-class charge accounts.
When run the Transactions Available for Reconciliation Report, the payment is showing in duplicate as well.

ERROR
AP check appears in more than once on the Cash Management Manual Clearing Form.
If you clear the Payment , the remaining row or rows  will be shown.
APP-SQLAP-10784: You are trying to clear a payment that was already cleared , will be shown when trying to clear any remaining rows.

STEPS TO REPRODUCE
The issue can be reproduced at will with the following steps: 

Payment Adjustments are being created automatically due to invoice adjustments when made to paid invoices (changing the invoice distribution account number or GL period).

1. In Payables create an Invoice
2. Validate and Account Invoice
3. Pay the Invoice
4. Account the Payment
5. Update the Paid Invoice and make an adjustment.
6.       Line # 1 for 100.00 booked to 24-AUG-2015, Account A
7.       Line # 2 create <100.00> booked to 24-AUG-2015,  Account A
8.       Line # 3 create 100.00 booked to 24-SEP-2015, Account A
9. Save, Validate and Account the Invoice
10. This creates Payment Adjustments
11. To see the Payment Adjustments
12. Navigate -> Payment - Entry -> Query the Document Number
13. Select Tool - > View Accounting Events
14. See the Payment Adjustments now Created

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.