GL Summary Account Upload – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
This upload can be used to import Summary Account Templates.
Report Parameters
Ledger
Oracle EBS Tables Used
gl_summary_templates, gl_summary_bc_options, fnd_lookup_values_vl, gl_budgets_require_journals_v, gl_ledgers
Report Categories
Related Reports
GL Budget Amounts Upload, AP Supplier Upload, CAC Interface Error Summary, GL Balance by Account Hierarchy, GL Account Analysis
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 | None |
| Blitz Report™ XML Import | GL_Summary_Account_Upload.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/gl-summary-account-upload/ |
GL Summary Account Upload - Case Study & Technical Analysis
Executive Summary
The GL Summary Account Upload is a utility tool designed to facilitate the mass creation or maintenance of Summary Accounts (Summary Templates) in Oracle General Ledger. Summary Accounts are special accounts that maintain pre-aggregated balances for a group of detail accounts, significantly speeding up financial reporting and inquiry. This tool allows users to define these templates in Excel and upload them, avoiding the complex manual setup screens.
Business Use Cases
- Performance Optimization: Quickly creates summary accounts to improve the performance of FSG reports and online account inquiries.
- Mass Creation: Enables the creation of dozens of summary templates (e.g., “Total Revenue by Region”, “Total Expenses by Department”) in a single batch operation.
- Standardization: Ensures consistent naming conventions and structure for summary accounts across different ledgers.
- Budgetary Control: Summary accounts are often used for budgetary control (checking funds at a summary level); this tool helps set up those controls efficiently.
Technical Analysis
Core Tables
GL_SUMMARY_TEMPLATES: The primary table storing the summary account definitions.GL_SUMMARY_BC_OPTIONS: Stores budgetary control options associated with the summary template.GL_LEDGERS: The ledger context.GL_CODE_COMBINATIONS: The resulting summary code combinations created by the template.
Key Joins & Logic
- Template Logic: The tool defines a template (e.g.,
D-T-D-D-D) where ‘D’ stands for Detail and ‘T’ for Total (Rollup). - Interface/API: It likely uses the
GL_SUMMARY_TEMPLATES_PKGor a similar internal API to validate and insert the template definition. - Concurrent Processing: Upon upload, it typically triggers the “Program - Maintain Summary Templates” concurrent request to build the summary account balances in the background.
Key Parameters
- Ledger: The ledger where the summary accounts will be created.
- Template Name: The unique name for the summary definition.
- Template Pattern: The D/T pattern defining the aggregation level.
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