GL Balance Drilldown – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.

Overview

Shows GL balance details by code combination. Uses gl_balances for standard queries, gl_je_lines when filtering by journal source/category or using JED balance types.

Report Parameters

Ledger ID, Period Name, Balance Type, Currency Code, Translated Flag, Actual Flag, Budget Name, Encumbrance Type, Journal Source, Journal Category, Multiplier

Oracle EBS Tables Used

gl_ledgers, gl_code_combinations_kfv, gl_balances, gl_budget_versions, gl_encumbrance_types, xxen_report_temp_ids, gl_je_headers, gl_je_lines, gl_periods, gl_je_sources_vl, gl_je_categories_vl

Report Categories

Enginatics

GL Account Analysis, GL Account Analysis (Distributions), GL Account Distribution Analysis, GL Journals (Drilldown) 11g, GL Journals (Drilldown)

Running This SQL Without Blitz Report

Some Oracle EBS SQL reports in this library require functions from the utility package xxen_util. Install it before running the SQL directly against your Oracle EBS database.

Download & Import Options

Resource Link
Excel Example Output None
Blitz Report™ XML Import GL_Balance_Drilldown.xml
Full SQL on Enginatics www.enginatics.com/reports/gl-balance-drilldown/

© 2026 Enginatics