My Oracle Support Banner

R12 CE: Bank Statement Amount Reconciled Is Null And The Status Is Reconciled (Doc ID 1955024.1)

Last updated on JUNE 07, 2018

Applies to:

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


Bank statement lines have status reconciled but amount reconciled is null

The lines are retrieved by the sentence:

select * from ce_statement_lines a
where status ='RECONCILED'
and not exists ( select 'x' from ce_statement_reconcils_all b
where b.statement_line_id = a.statement_line_id ) ;


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
 Standard Patching Process
 Patch Wizard
 Have more questions?

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