R12:CE Payment In AP Not Available For Reconciliation In Cash Management
Last updated on OCTOBER 16, 2017
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 .
2 - For the associated Bank Statement Line, run the Celisth.sql diagnostic report.
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 = 439202
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 (439202)) ;
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 (439202))) ;
4 - Upload the following to the SR.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms