AR To GL Reconciliation Report Takes More Than 5hrs To Complete (Doc ID 1466048.1)

Last updated on AUGUST 24, 2016

Applies to:

Oracle Receivables - Version 12.0.6 and later
Information in this document applies to any platform.

Symptoms

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)

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute      1   4018.96   27965.82   40146526  124814339        652         399
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        2   4018.96   27965.82   40146526  124814339        652         399

Cause

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