Bank Statement Amount Reconciled Is Null And The Status Is Reconciled

(Doc ID 1955024.1)

Last updated on OCTOBER 03, 2017

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


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