Skip to the content.

GL Header Categories Summary – 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

Master data report showing ledger, category and source definitions across multiple ledgers.

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

Expand Sources

Oracle EBS Tables Used

gl_ledgers, gl_period_statuses, gl_je_batches, gl_je_headers, gl_je_categories_vl

Report Categories

Enginatics

GL Journals 11i, GL Account Analysis (Drilldown) (with inventory and WIP), GL Journals, GL Account Distribution Analysis, GL Account Analysis, GL Journals (Drilldown) 11g, GL Journals (Drilldown)

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 GL Header Categories Summary 23-Jul-2017 160240.xlsx
Blitz Report™ XML Import GL_Header_Categories_Summary.xml
SQL Source GL Header Categories Summary.sql
Full Report on Enginatics www.enginatics.com/reports/gl-header-categories-summary/

GL Header Categories Summary - Case Study & Technical Analysis

Executive Summary

The GL Header Categories Summary report provides a high-level statistical overview of General Ledger journal entries, grouped by Ledger, Source, and Category. It is designed to analyze the volume and composition of journal entries within the system. This report is valuable for system administrators and finance managers to understand data trends, identify high-volume integration points, and monitor the usage of manual vs. automated journals.

Business Use Cases

Technical Analysis

Core Tables

Key Joins & Logic

Key Parameters


© Enginatics GmbH