FND Flex Hierarchies (Rollup Groups) – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™. Oracle EBS module: Application Object Library · all Application Object Library reports
Overview
Flex value sets with rollup groups
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
None
Oracle EBS Tables Used
fnd_flex_value_sets, fnd_flex_hierarchies_vl
Report Categories
Related Reports
FND Rollup Groups, FND Flex Value Hierarchy, FND Flex Values, FND Flex Value Upload, GL Chart of Accounts Mapping Rules, AR Aging, AP Invoice Upload, ONT System Parameters, PO Headers and Lines
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 | FND_Flex_Hierarchies_Rollup_Groups.xml |
| SQL Source | FND Flex Hierarchies (Rollup Groups).sql |
| Full Report on Enginatics | www.enginatics.com/reports/fnd-flex-hierarchies-rollup-groups/ |
Executive Summary
The FND Flex Hierarchies (Rollup Groups) report documents the Rollup Groups defined for value sets. Rollup Groups are used to create summary accounts in General Ledger or to group values for reporting purposes.
Business Challenge
- Summary Account Management: Verifying which rollup groups exist before creating new summary templates.
- Reporting Structure: Understanding how values are grouped for high-level financial reporting.
The Solution
This Blitz Report lists the Rollup Groups:
- Value Set: The value set the group belongs to.
- Rollup Group Name: The code and description of the group.
- Hierarchy: Shows the relationship between the group and the value set.
Technical Architecture
The report queries FND_FLEX_HIERARCHIES_VL and FND_FLEX_VALUE_SETS.
Parameters & Filtering
- None: The report typically dumps all hierarchies or can be filtered by Value Set in the output.
Performance & Optimization
- Lightweight: This is a small configuration table.
FAQ
- Q: How do I assign values to these groups?
- A: You assign a Rollup Group to a specific Parent Value in the “Segment Values” form. Use the “FND Flex Values” report to see which values are assigned to which group.
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