R12: Bank Statement Line Is Showing As "Reconciled" But There Are No Reconciliation Record (Doc ID 2102906.1)

Last updated on MARCH 01, 2017

Applies to:

Oracle Cash Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Problem Statement:
----------------
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.

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')) ;

Cause

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