GLTRBAL2 Trial Balance - Additional Segment Detail (R12 Taking A Long Time To Complete)
(Doc ID 2054133.1)
Last updated on JUNE 07, 2021
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
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