My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

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

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
 1. Bug Summary
 2. Fixed File(s)
 3. Recommended Patch(es)
 4. Solution Steps
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.