Skip to content

GL Header Categories Summary

Directory actions

More options

Directory actions

More options

Latest commit

 

History

History

GL Header Categories Summary

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
DESCRIPTION.md
DESCRIPTION.md
 
 
GL Header Categories Summary.sql
GL Header Categories Summary.sql
 
 
README.md
README.md
 
 

README.md

layout default
title GL Header Categories Summary | Oracle EBS SQL Report
description Master data report showing ledger, category and source definitions across multiple ledgers.
keywords Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, Header, Categories, Summary, gl_ledgers, gl_period_statuses, gl_je_batches
permalink /GL%20Header%20Categories%20Summary/

GL Header Categories Summary – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.

Overview

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

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

Related Reports

GL Account Analysis, GL Journals (Drilldown) 11g, 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 GL Header Categories Summary 23-Jul-2017 160240.xlsx
Blitz Report™ XML Import GL_Header_Categories_Summary.xml
Full SQL 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

  • Data Volume Analysis: Identifies which journal sources (e.g., Payables, Receivables, Spreadsheet) are generating the most entries, helping to plan for archiving or performance tuning.
  • Process Monitoring: Tracks the usage of specific journal categories (e.g., "Adjustment", "Reclass") to detect unusual patterns in manual journal entry.
  • Period-End Review: Provides a summary of activity for a closed period to ensure all expected subledger feeds have been received.
  • Audit Scoping: Helps auditors understand the landscape of financial transactions to determine where to focus their detailed testing (e.g., focusing on "Manual" sources).

Technical Analysis

Core Tables

  • GL_JE_HEADERS: The main table containing journal entry headers.
  • GL_JE_BATCHES: Stores batch-level information.
  • GL_JE_CATEGORIES_VL: Provides user-friendly names for journal categories.
  • GL_LEDGERS: Defines the ledger context.
  • GL_PERIOD_STATUSES: Used to validate period information.

Key Joins & Logic

  • Aggregation: The query performs a COUNT(*) on GL_JE_HEADERS, grouping by LEDGER_ID, JE_SOURCE, and JE_CATEGORY.
  • Source/Category Resolution: It joins to GL_JE_CATEGORIES_VL to display the category name. The Source is typically stored directly in GL_JE_HEADERS (or GL_JE_SOURCES_VL if needed for translation).
  • Period Context: It likely filters or groups by PERIOD_NAME to provide a time-based view of the data.
  • Ledger Context: Joins to GL_LEDGERS to report the Ledger Name.

Key Parameters

  • Expand Sources: A flag to determine if the report should break down the counts by Journal Source or provide a higher-level summary.

Useful Links

© 2026 Enginatics