My Oracle Support Banner

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:

Oracle Cash Management - Version 12.0.0 to 12.2.6 [Release 12 to 12.2]
Information in this document applies to any platform.


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.

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.

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





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

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