GL Summary Account Upload – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
Adds and deletes GL summary account templates of a ledger. Each row is one summary template.
The segment columns hold the summary type of each segment, as in the Summary Accounts window: D (Detail) creates a summary account for each detail value of the segment, T (Total) one summary account across all values, and the name of a rollup group one summary account for each parent value of that group.
Add creates the template and Delete removes it with its summary accounts. Both run the Add/Delete Summary Accounts program, which creates or deletes the summary accounts and maintains their balances from the Earliest Period on. The Request Log column links to its log.
An existing template cannot be changed: delete it and add it again. The budgetary control columns (Funds Check Level, Debit or Credit, Amount Type, Boundary, Funding Budget) apply to ledgers with budgetary control and are taken only when a template is added.
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
Ledger, Upload Mode
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, GL Setup Upload, AP Supplier Upload, GL Balance by Account Hierarchy, GL Account Analysis, GL Code Combinations, GL Balance, GL Account Distribution Analysis, GL Account Upload 11i
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 | Example |
| Blitz Report™ XML Import | GL_Summary_Account_Upload.xml |
| SQL Source | GL Summary Account Upload.sql |
| Full Report 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
© Enginatics GmbH