R12: CE: Bank Statement Line Is Showing As "Reconciled" But There Are No Reconciliation Record
(Doc ID 2102906.1)
Last updated on OCTOBER 07, 2024
Applies to:
Oracle Cash Management - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
In R12.X
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
*Nothing appears
Verification query
-------------------
SELECT *
FROM CE_STATEMENT_HEADERS
WHERE STATEMENT_HEADER_ID IN
SELECT STATEMENT_HEADER_ID
FROM CE_STATEMENT_LINES CSL
WHERE CSL.STATUS = 'RECONCILED'
AND NOT EXISTS(
SELECT 1
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')) ;
-------------------
SELECT *
FROM CE_STATEMENT_HEADERS
WHERE STATEMENT_HEADER_ID IN
SELECT STATEMENT_HEADER_ID
FROM CE_STATEMENT_LINES CSL
WHERE CSL.STATUS = 'RECONCILED'
AND NOT EXISTS(
SELECT 1
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')) ;
Changes
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |