R12/CE: Bank Statement Line is Shown as Reconciled Though There Are Unreconcilied Transactions (Doc ID 2232553.1)

Last updated on OCTOBER 27, 2022

Applies to:

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

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