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.
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
Current Report version being used: GLRTB2.rdf: 120.6.12010000.1
Upgrade from 11i to R12
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms