FND Flex Hierarchies (Rollup Groups) – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
Flex value sets with rollup groups
Report Parameters
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, PO Headers and Lines, FA Asset Retirements, AP Invoice Upload, ONT System Parameters
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 | FND_Flex_Hierarchies_Rollup_Groups.xml |
| Full SQL 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
© 2026 Enginatics