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

Last updated on FEBRUARY 27, 2017

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

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