My Oracle Support Banner

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

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