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

Last updated on JUNE 11, 2024

Applies to:

Symptoms

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.

STEPS
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.

     Select * from CE_STATEMENT_RECONCILS_ALL
     where REFERENCE_ID = <CHECK_ID>
     and REFERENCE_TYPE = 'PAYMENT
     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.

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.