My Oracle Support Banner

R12/CE: Payment In AP Not Available For Reconciliation In Cash Management (Doc ID 2125400.1)

Last updated on SEPTEMBER 14, 2021

Applies to:

Oracle Cash Management - Version 12.1.1 and later
Information in this document applies to any platform.


Payable Payment is not available for Reconciliation against a Bank Statement.
The Payment is Negotiable in Payables, but unable to find the Payment in Cash Management to Reconcile.

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

1.) Navigate ->  Bank Statements -> Bank Statements and Reconciliation
2.) Query the Bank Statement and the Bank Statement Line that is Unreconciled.
3.) Select Find Transactions and try to Find the Payment Number


1 -  For the associated Payment, run the Aplisth.sql diagnostic report .
                Please refer to : Oracle Payables Invoice Data Collection Test (Doc ID 732163.1) for instructions.

2 -  For the associated Bank Statement Line, run the Celisth.sql diagnostic report.
                 Please refer to :  R11i/12: CE: Cash Management Support Tools: CELIST scripts and Steps for 11i and R12 (Doc ID 1570336.1)

3 -  Run the following queries against the tables in CE to see the bank statement lines the payment has been reconciled with.

     Substitute the REFERENCE_ID with the CHECK_ID of the Payment.

     where REFERENCE_ID = <CHECK_ID>
     order by statement_line_id , creation_date ;

     Select * from CE_STATEMENT_LINES
     where statement_line_id in (Select h.statement_line_id from CE_STATEMENT_RECONCILS_ALL h
     where h.reference_type = 'PAYMENT' and h.reference_id in (<CHECK_ID>)) ;

     Select * from CE_STATEMENT_HEADERS
     where statement_header_id in (Select l.statement_header_id from CE_STATEMENT_LINES l
     where l.statement_line_id in (Select h.statement_line_id from CE_STATEMENT_RECONCILS_ALL h
     where h.reference_type = 'PAYMENT' and h.reference_id in (<CHECK_ID>))) ;

 4 - Upload the output to the SR.




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.