GL Journals (Drilldown) 11g – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
GL batches and journals report, including amounts and attachments.This report is used by the GL Financial Statement and Drilldown report, to show subledger details.
Report Parameters
Ledger, Period, Ledger ID, Journal Source, Journal Category, Status, Batch, Batch ID, Journal, Journal Header ID, Journal Line Num, Concatenated Segments, Code Combination ID, Currency, Show Attachment Details, Balance Type, Budget Name, Encumbrance Type, Amount Type
Oracle EBS Tables Used
gl_code_combinations_kfv, per_people_f, gl_je_sources_vl, gl_je_categories_vl, gl_budget_versions, gl_encumbrance_types, gl_daily_conversion_types, gl_je_headers, gl_system_usages, zx_rates_b, gl_ledgers, gl_periods, gl_je_batches, gl_je_lines, gl_je_lines_recon, gcck, fnd_attached_documents, fnd_documents, fnd_documents_tl, fnd_document_datatypes, fnd_document_categories_vl, fnd_lobs, fnd_documents_short_text, fnd_documents_long_text
Report Categories
Related Reports
GL Account Analysis (Drilldown) (with inventory and WIP), GL Journals, GL Account Distribution Analysis, GL Account Analysis, 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_Journals_Drilldown_11g.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/gl-journals-drilldown-11g/ |
GL Journals (Drilldown) 11g - Case Study & Technical Analysis
Executive Summary
The GL Journals (Drilldown) 11g report is a version of the drill-down report tailored for Oracle Database 11g environments or specific legacy configurations. It shares the same functional purpose as the standard drill-down report—providing detailed journal views from summary reports—but may contain SQL syntax or optimization hints specific to the 11g optimizer to ensure performance stability in that environment.
Business Use Cases
- Legacy System Support: Ensures that organizations running on older Oracle database versions maintain fast and reliable drill-down capabilities.
- Performance Tuning: May include specific optimizer hints (
/*+ INDEX(...) */) that were necessary in 11g but might be deprecated or unnecessary in 12c/19c. - Consistent User Experience: Provides the same “click-through” analysis experience for end-users regardless of the underlying database version.
Technical Analysis
Core Tables
GL_JE_HEADERSGL_JE_LINESGL_JE_BATCHES
Key Joins & Logic
- 11g Specifics: The primary difference lies in the SQL construction. It might avoid certain analytical functions or lateral joins that were introduced or optimized in later versions.
- Drill-down Context: Accepts parameters like
JE_HEADER_IDto fetch specific records.
Key Parameters
- Journal Header ID: Target journal to display.
- Period: Accounting period context.
Useful Links
- Blitz Report™ – World’s Fastest Oracle EBS Reporting Tool
- Oracle Discoverer Replacement – Import Worksheets into Blitz Report™
- Oracle EBS Reporting Toolkits by Blitz Report™
- Blitz Report™ FAQ & Community Q&A
- Supply Chain Hub by Blitz Report™
- Blitz Report™ Customer Case Studies
- Oracle EBS Reporting Blog
- Oracle EBS Reporting Resource Centre
© 2026 Enginatics