Reports Performance Issue: Journal Entries Report for Receivables Has Poor Performance - Take Two to Three Hours to Complete (Doc ID 1624543.1)

Last updated on AUGUST 24, 2016

Applies to:

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

Symptoms

Attempting to run the Journal Entries Report and find it has a poor performance issue.

The following statement is what is causing the performance:

 PARSING IN CURSOR #4574955928 len=4711 dep=0 uid=192 oct=2 lid=192
 tim=14165871803803 hv=1786360453 ad='700000247bac8d0' sqlid='fpg7hrdp7mcn5'
 INSERT  /*+ APPEND */ INTO ar_journal_interim

 TKPROF:
 Trace file: MIG_ora_34275548_ANONYMOUS.trc
 Sort options: default
 ...
 INSERT  /*+ APPEND */ INTO ar_journal_interim
 (        status,
        actual_flag,
        request_id,
 created_by,
..
       and ctt.type in ( 'INV','GUAR','DEP', 'CM', 'DM', 'CB')
    and ctlgd.gl_date between
                      fnd_date.canonical_to_date('2013/06/01 00:00:00')
               and  
                     fnd_date.canonical_to_date('2013/06/30 00:00:00')
 AND (ct.ORG_ID in (82))

 call     count       cpu    elapsed       disk      query    current       rows
 ------- ------  -------- ---------- ---------- ---------- ---------- ----------
 Parse        1      0.05       0.09          0          6          0       0
 Execute      1    336.11    3483.38    2067340   19753899      26285       94900
 Fetch        0      0.00       0.00          0          0          0         0
 ------- ------  -------- ---------- ---------- ---------- ---------- ----------
total        2    336.16    3483.48    2067340   19753905      26285       94900

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