R12/CE: Payment In AP Not Available For Reconciliation In Cash Management
(Doc ID 2125400.1)
Last updated on AUGUST 11, 2023
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.
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.
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