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
Run this report in Excel in seconds: download Blitz Report™ free (your first 30 reports are free) or try it in the online demo.
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, Exclude Reversed Journals, 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 Journals, GL Journals (Drilldown) 11g, GL Account Analysis, GL Account Analysis (Drilldown) (with inventory and WIP), GL Account Distribution Analysis, GL Account Analysis 11g, GL Account Analysis (Drilldown), GL Journals 11i, AP Invoices and Lines
Running This SQL Without Blitz Report
The SQL source can be run in any SQL client. Some Oracle EBS SQL reports in this library use functions from the utility package xxen_util – install it first. Blitz Report™ adds parameters, Excel output with pivots, scheduling and security on top.
Download & Import Options
| Resource | Link |
|---|---|
| Excel Example Output | Example |
| Blitz Report™ XML Import | GL_Journals_Drilldown.xml |
| SQL Source | GL Journals (Drilldown).sql |
| Full Report 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
© Enginatics GmbH