AR To GL Reconciliation Report Takes More Than 5hrs To Complete
(Doc ID 1466048.1)
Last updated on FEBRUARY 13, 2019
Oracle Receivables - Version 12.0.6 and later Information in this document applies to any platform.
AR to GL Reconciliation report takes more than 5hrs to complete.
Following statement is slow:
insert into ar_gl_recon_gt(code_combination_id, receivables_dr,receivables_cr, account_type, account_type_code) (select dat.code_combination_id, sum(nvl(acctd_amount_dr,0)) receivables_debit, sum(nvl(acctd_amount_cr,0)) receivables_credit, lookup.description account_type, gc.account_type account_type_code from ( ..
group by b.ae_header_id,b.ae_line_num,b.code_combination_id ) dat, gl_code_combinations gc, gl_lookups lookup where dat.code_combination_id = gc.code_combination_id and lookup.lookup_code = gc.account_type and lookup.lookup_type = 'ACCOUNT TYPE' group by dat.code_combination_id,lookup.description, gc.code_combination_id,gc.account_type)