GL Journals (Drilldown) – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
** This report is used by the GL Financial Statement and Drilldown report, to show Journal details. **
GL batches and journals report, including amounts and attachments.To enable next level drilldown below columns should be present in Display columns of the custom templates Drill To Subledger Drill To Journal Attachment Drill To Full Journal
Report Parameters
Ledger, Period, Ledger ID, Journal Source, Journal Category, Posting Status, Batch, Batch ID, Journal, Journal Header ID, Journal Line Num, Concatenated Segments, Code Combination ID, Restrict CCIDs through GTT, Restrict JHI through GTT, Currency, Show Attachment Details, Balance Type, Budget Name, Encumbrance Type, Amount Type, Creation Date From, Creation Date To, Created By, Posted Date From, Posted Date To, Funds Status, Reference
Oracle EBS Tables Used
per_people_f, 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_sources_vl, gl_je_categories_vl, gl_je_lines, gl_je_lines_recon, gl_code_combinations_kfv, 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), GL Account Analysis (Drilldown) (with inventory and WIP), GL Account Distribution Analysis
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.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/gl-journals-drilldown/ |
GL Journals (Drilldown) - Case Study & Technical Analysis
Executive Summary
The GL Journals (Drilldown) report is a specialized variation of the standard GL Journals report, specifically engineered to serve as the “target” for drill-down operations from high-level financial statements (like the FSG report). It is optimized to accept specific context parameters (such as a Journal Header ID or a specific Account/Period combination) passed from a parent report, allowing users to instantly view the granular details behind a summary balance.
Business Use Cases
- Interactive Financial Analysis: Enables a seamless workflow where a CFO or controller reviewing a Balance Sheet can click on a “Cash” balance and immediately see the list of journals comprising that figure.
- Variance Investigation: Facilitates rapid root-cause analysis of budget-to-actual variances by drilling down to the transaction level.
- Subledger Connectivity: Often acts as a bridge, allowing further drill-down from the GL Journal line to the underlying Subledger transaction (e.g., the specific AP Invoice).
Technical Analysis
Core Tables
GL_JE_HEADERS: The entry point for the drill-down, often filtered byJE_HEADER_ID.GL_JE_LINES: The detailed lines associated with the header.GL_IMPORT_REFERENCES: (Implicitly used in subledger drill-downs) Links GL lines back to XLA/Subledger tables.
Key Joins & Logic
- Parameter-Driven Filtering: Unlike the standard report which uses broad ranges (Date, Period), this report is designed to handle specific IDs (
JE_HEADER_ID,JE_LINE_NUM) or precise combinations (CODE_COMBINATION_ID) passed from the calling application. - Performance Optimization: The query is likely tuned for “lookup by ID” operations to ensure instant response times during interactive drill-down sessions.
Key Parameters
- Journal Header ID: The primary key for a specific journal entry.
- Batch ID: The primary key for a specific batch.
- Code Combination ID: The unique identifier for an account string.
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