GL Journals (Drilldown) 11g – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™. Oracle EBS module: General Ledger · all General Ledger reports
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.
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, 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, 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 (Drilldown), GL Journals, 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, GL Setup Upload
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_11g.xml |
| SQL Source | GL Journals (Drilldown) 11g.sql |
| Full Report 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
© Enginatics GmbH