GLTRBAL2 Trial Balance - Additional Segment Detail (R12 Taking A Long Time To Complete) (Doc ID 2054133.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

After upgrade from 11i to R12, The Trial Balance - Additional Segment Detail is taking a long time to complete

The Oracle Standard Report Trial Balance - Additional Segment Detail (R12) is taking over 40 minutes to complete when using similar parameters in an 11i
environment using the Oracle Standard Report Trial Balance - Summary 2 is completing in a couple of minutes.


This has never run in a more timely manner since upgrade to R12.
Issue is being seen in all instances.
No other noted performance issue with any other General Ledger (GL) standard Report.

The following has been done, but the issue remains:
a) Run the gather schema stat program with a minimum 30% sample size for GL
and APPS schemas. 
b) Run the standard program - Program - Optimizer with yes/yes as
parameters.

Current Report version being used: GLRTB2.rdf: 120.6.12010000.1


Changes

 Upgrade from 11i to R12

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