R12: CE: Bank Statement Line Is Showing As "Reconciled" But There Are No Reconciliation Record
(Doc ID 2102906.1)
Last updated on JUNE 09, 2023
Applies to:Oracle Cash Management - Version 12.1.3 and later
Information in this document applies to any platform.
Payment details are not appearing for a 'Reconciled' Statement line.
The statement line is showing as Reconciled in Bank statement reconciliation window, but when user clicks on Reconciled it is not showing any transaction against it.
Issue can be reproduce with the following steps:
*Navigate CE: Bank statement and reconciliation
*Query the Bank Statement
*Click on Lines
*Check the Status is reconciled
*Click on Reconciled button
WHERE STATEMENT_HEADER_ID IN
FROM CE_STATEMENT_LINES CSL
WHERE CSL.STATUS = 'RECONCILED'
AND NOT EXISTS(
FROM CE_STATEMENT_RECONCILS_ALL CRE
WHERE CRE.STATEMENT_LINE_ID = CSL.STATEMENT_LINE_ID
AND CRE.CURRENT_RECORD_FLAG = 'Y'
AND CRE.STATUS_FLAG = 'M')) ;
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