My Oracle Support Banner

GL Trial Balance Reports GLTRBAL1 GLBRBAL2 Are Taking Over an Hour To Complete (Doc ID 3048693.1)

Last updated on SEPTEMBER 25, 2024

Applies to:

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

Symptoms

GL Trial Balance Reports GLTRBAL1 and GLBRBAL2 are taking up to over an hour to complete.

Customer expects these to complete promptly, so that month end activities are not delayed.

There is one slow statement selecting from GL_BALANCES and GL_CODE_COMBINATIONS.

To reproduce the issue, submit reports GLTRBAL1 and GLBRBAL2.

Once completed see that the run times are approximately an hour for each report.

Cause

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
Symptoms
Cause
Solution
References


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