GL FSG Reports – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™. Oracle EBS module: General Ledger · all General Ledger reports
Overview
Financial Statement Generator reports
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
Structure Name, Row Order
Oracle EBS Tables Used
rg_reports_v, fnd_id_flex_structures_vl
Report Categories
Related Reports
GL FSG Row Orders, CAC Inventory Organization Summary, GL Ledgers and Legal Entities, 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 | GL FSG Reports 09-Jan-2022 110407.xlsx |
| Blitz Report™ XML Import | GL_FSG_Reports.xml |
| SQL Source | GL FSG Reports.sql |
| Full Report on Enginatics | www.enginatics.com/reports/gl-fsg-reports/ |
GL FSG Reports - Case Study & Technical Analysis
Executive Summary
The GL FSG Reports report is a system administration and documentation tool that lists the definitions of Financial Statement Generator (FSG) reports defined in the system. It provides a catalog of existing financial reports, including their associated row sets, column sets, and content sets. This report is essential for maintaining the financial reporting library, identifying obsolete reports, and auditing report definitions during upgrades or re-implementations.
Business Use Cases
- Report Inventory: Creates a master list of all financial reports (Balance Sheets, P&L, Cash Flow) configured in the system.
- Change Management: Helps track changes to report definitions and ensures that the correct versions of row and column sets are being used.
- Cleanup and Optimization: Identifies unused or duplicate reports that can be retired to declutter the request submission screens.
- Migration Planning: Critical during system upgrades or migrations to document which FSG reports need to be moved or re-tested.
- Security Auditing: Can be used to verify which reports are enabled and available for specific responsibilities (if joined with security data).
Technical Analysis
Core Tables
RG_REPORTS_V: A view containing the header-level definition of FSG reports (Report Name, Title, Row Set ID, Column Set ID).RG_REPORT_AXIS_SETS: Stores the definitions of Row Sets and Column Sets.FND_ID_FLEX_STRUCTURES_VL: Provides the Chart of Accounts structure name associated with the report.
Key Joins & Logic
- Report Definition: The query selects from
RG_REPORTS_Vto get the main report attributes. - Structure Association: Joins to
FND_ID_FLEX_STRUCTURES_VLviaID_FLEX_NUM(Chart of Accounts ID) to indicate which accounting structure the report is built for. - Component Resolution: While this specific query might focus on the report header, it logically links to
RG_REPORT_AXIS_SETSto resolve the names of the Row and Column sets used by the report.
Key Parameters
- Structure Name: Filters the list of reports by the Chart of Accounts structure (e.g., “Corporate Accounting Flexfield”).
- Row Order: (Optional) Filters by the specific Row Order definition used in the report.
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