My Oracle Support Banner

GLRTBD General Ledger Trial Balance is Taking Huge Time to Complete (Doc ID 1625594.1)

Last updated on JANUARY 31, 2024

Applies to:

Oracle General Ledger - Version 12.1.3 and later
Information in this document applies to any platform.
Report:GLRTBD.RDF - Detail Trial Balance / Foreign Currency Detail Trial Balance

Symptoms

On : 12.1.3 version, Standard Reports & Inquiries

ACTUAL BEHAVIOR
---------------
Trial Balance - Detail report is performing poorly/slowly after upgrade
The R11.5.10.2 version of this report runs in less than 10 minutes
The R12.1.3 version of this report takes between 30-45 minutes to complete.

EXPECTED BEHAVIOR
-----------------------
It is expected that the report will run in a reasonable time.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Reports > Request > Standard
2. Select Trial Balance - Detail
3. Enter parameters and submit

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.