My Oracle Support Banner

R12: GL: Trial Balance Report(GLTRBAL1) Performance Issue After Upgrading From 12.1.3 to 12.2.9 (Doc ID 3076277.1)

Last updated on MARCH 11, 2025

Applies to:

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

Symptoms

Trial Balance Report(GLTRBAL1) performance issue after upgrading from 12.1.3 to 12.2.9

Identified below problematic sql id in AWR Report:

sql id: cyhns6c67ffzy

SELECT /*+ opt_param('_nlj_batching_enabled', 0) no_nlj_prefetch(b) full(cc) use_hash(cc)*/ MAX ( LR . TARGET_LEDGER_NAME ) PBLNAME , MAX ( LR . TARGET_LEDGER_CATEGORY_CODE ) TARGET_LEDGER_CATEGORY_CODE , MAX ( LR . RELATIONSHIP_TYPE_CODE ) RELATIONSHIP_TYPE_CODE , MAX ( CC.SEGMENT1 ) PBDATA , MAX ( CC.SEGMENT3 ) ACCTDATA , decode ( : P_PERIOD_TYPE , 'PTD' , SUM ( DECODE ( : P_CURRENCY_TYPE , 'T' , NVL ( BEGIN_BALANCE_DR , 0 ) - NVL ( BEGIN_BALANCE_CR , 0 ) , 'S' , NVL ( BEGIN_BALANCE_DR , 0 ) - NVL ( BEGIN_BALANCE_CR , 0 ) , 'E' , DECODE ( BAL . TRANSLATED_FLAG , 'R' , NVL ( BEGIN_BALANCE_DR , 0 ) - NVL ( BEGIN_BALANCE_CR , 0 ) , NVL ( BEGIN_BALANCE_DR_BEQ , 0 ) - NVL ( BEGIN_BALANCE_CR_BEQ , 0 ) ) ) )

STEPS TO REPRODUCE:

1. Login to EBS application
2. Navigate to General Ledger Responsibility > Run Request > Run GLTRBAL1: Trial Balance 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


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