R12 CE: Bank Statement Amount Reconciled Is Null And The Status Is Reconciled
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 ) ;
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