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!