My Oracle Support Banner

R12/CE: Bank Statement Line Is Showing As "Reconciled" But There Are No Reconcilied Transactions (Doc ID 2232553.1)

Last updated on NOVEMBER 05, 2018

Applies to:

Oracle Cash Management - Version 12.0.0 to 12.2.6 [Release 12 to 12.2]
Information in this document applies to any platform.

Symptoms

Bank Statement Line Is Showing As "Reconciled" But There Are No Reconciled Transaction seen.

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.

Take results in excel with column headings:

a. Find if the Payment Reconciliation trail is not proper:

select * from
ce_statement_reconcils_all a
where reference_type ='PAYMENT'
and current_record_flag ='N'
and status_flag ='M'
and not exists ( select 'x' from ce_statement_reconcils_all b
where a.je_header_id = b.je_header_id
and a.reference_type = b.reference_type
and a.reference_id = b.reference_id
and b.current_record_flag ='Y');

 

b. Find if the Receipt Reconciliation trail is not proper:
select * from
ce_statement_reconcils_all a
where reference_type ='RECEIPT'
and current_record_flag ='N'
and status_flag ='M'
and not exists ( select 'x' from ce_statement_reconcils_all b
where a.je_header_id = b.je_header_id
and a.reference_type = b.reference_type
and a.reference_id = b.reference_id
and b.current_record_flag ='Y')

 

c. Find if the Journal Reconciliation trail is not proper:

 

select * from
ce_statement_reconcils_all a
where reference_type ='JE_LINE'
and current_record_flag ='N'
and status_flag ='M'
and not exists ( select 'x' from ce_statement_reconcils_all b
where a.je_header_id = b.je_header_id
and a.reference_type = b.reference_type
and a.reference_id = b.reference_id
and b.current_record_flag ='Y')

 

 

 

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
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.