GL Summary Templates – Oracle EBS SQL Report

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

Overview

Master data report showing GL summary and concatenation templates based on ledger, company, department, account, sub-account, and product segments, and including information for the group, ledger set, ledger, ledger category, currency and chart of accounts.

Report Parameters

Chart of Accounts, Non Rollup Group Only

Oracle EBS Tables Used

gl_ledgers, gl_summary_templates

Report Categories

Enginatics

Related Reports

GL Balance by Account Hierarchy, GL Code Combinations, GL Summary Account Upload, AP Supplier Upload, AR Open Balances Revaluation, CST Period Close Subinventory Value Summary

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 Summary Templates 09-Jul-2019 140636.xlsx
Blitz Report™ XML Import	GL_Summary_Templates.xml
Full SQL on Enginatics	www.enginatics.com/reports/gl-summary-templates/

GL Summary Templates - Case Study & Technical Analysis

Executive Summary

The GL Summary Templates report lists the existing Summary Account templates defined in the system. It provides a catalog of the pre-aggregated balance structures currently active. This report is crucial for understanding the performance optimization strategy of the General Ledger and for auditing which summary levels are being maintained.

Business Use Cases

• Performance Tuning: Helps identify if too many summary templates exist (which can slow down posting) or if key templates are missing (which slows down reporting).
• Redundancy Check: Identifies duplicate or overlapping templates that might be wasting system resources.
• Impact Analysis: Before deleting a rollup group or segment value, this report helps identify which summary templates rely on it.
• Documentation: Provides a clear map of the “Total” accounts available for reporting users (e.g., “Use the ‘Total Dept’ summary account for faster queries”).

Technical Analysis

Core Tables

• GL_SUMMARY_TEMPLATES: Stores the template header and the definition string (e.g., D-T-D).
• GL_LEDGERS: Identifies the ledger.
• GL_ACCOUNT_HIERARCHIES: (Implicit) The logic relies on the hierarchies defined in the chart of accounts.

Key Joins & Logic

• Template Decoding: The report parses the TEMPLATE column to show which segments are “Detail” and which are “Summary”.
• Status Check: Checks if the template is ENABLED and if the status is CURRENT (meaning balances are up to date).
• Ledger Association: Joins to GL_LEDGERS to show the scope of the template.

Key Parameters

• Chart of Accounts: Filter by structure.
• Non Rollup Group Only: A filter to show templates that might be using “Parent” values directly rather than Rollup Groups (depending on configuration).

---

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