Search Results gl_summary_templates




Overview
Explore in AI Chat

Overview

The GL_SUMMARY_TEMPLATES table is a core data object within the Oracle E-Business Suite General Ledger (GL) module. It serves as the master repository for defining summary account templates. These templates are foundational for creating summary accounts, which are high-level parent accounts that consolidate balances from a range of detailed child accounts. The primary role of this table is to store the configuration and metadata for these templates, enabling efficient financial reporting, consolidation, and performance optimization by reducing the volume of detail that must be processed during period-end closing and reporting activities.

Key Information Stored

The table's primary key is the TEMPLATE_ID, a unique identifier for each summary template definition. Based on the documented foreign key relationships, other critical columns include LEDGER_ID, which links the template to a specific ledger (via GL_SETS_OF_BOOKS_11I), establishing the template's operational context. The FUNDING_BUDGET_VERSION_ID column links to GL_BUDGET_VERSIONS, indicating its use in budgetary control scenarios. The MAX_CODE_COMBINATION_ID column references GL_CODE_COMBINATIONS, likely identifying the highest allowable code combination ID for the template's range. Collectively, these columns define the template's scope, purpose, and relationship to the chart of accounts and ledger structure.

Common Use Cases and Queries

A primary use case is identifying all summary templates defined for a specific ledger to understand the consolidation hierarchy. A common diagnostic query involves joining with GL_SETS_OF_BOOKS_11I (or GL_LEDGERS in R12) to list templates by ledger name. For performance tuning or data purging initiatives, analysts may query this table to assess which templates are referenced in large transactional tables like GL_BALANCES or GL_BC_PACKETS. The user's search for "rg_dss_requests" suggests an interest in reporting or data extraction; while not directly related, summary templates are critical for building efficient DSS (Decision Support System) reporting layers that rely on pre-consolidated balances.

  • Sample Query: Retrieve template details for a ledger:
    SELECT gst.template_id, gst.name, sob.name ledger_name FROM gl.gl_summary_templates gst, gl.gl_sets_of_books_11i sob WHERE gst.ledger_id = sob.set_of_books_id;

Related Objects

The GL_SUMMARY_TEMPLATES table has extensive relationships throughout the General Ledger schema, as evidenced by the provided metadata. Its TEMPLATE_ID column is a foreign key in numerous core tables, highlighting its central role. Key documented relationships include: