| layout | default |
|---|---|
| title | FND Rollup Groups | Oracle EBS SQL Report |
| description | Flex value sets with rollup groups (FND Flex Hierarchies) – Oracle E-Business Suite SQL report |
| keywords | Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, FND, Rollup, Groups, fnd_flex_values, fnd_flex_value_sets, fnd_flex_hierarchies_vl |
| permalink | /FND%20Rollup%20Groups/ |
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Flex value sets with rollup groups (FND Flex Hierarchies)
Flex Value Set, Rollup Group
fnd_flex_values, fnd_flex_value_sets, fnd_flex_hierarchies_vl
FND Flex Value Hierarchy, FND Flex Values, FND Flex Value Upload, FND Flex Hierarchies (Rollup Groups), AP Invoice Upload
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.
| Resource | Link |
|---|---|
| Excel Example Output | FND Rollup Groups 25-Sep-2025 104414.xlsx |
| Blitz Report™ XML Import | FND_Rollup_Groups.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/fnd-rollup-groups/ |
The FND Rollup Groups report lists Flex Value Sets that utilize rollup groups, which are used to define summary relationships (hierarchies) for segment values. This is essential for financial reporting and other processes that rely on parent-child relationships within chart of accounts or other flexfields.
In General Ledger and other modules, "Parent" values are used to sum up "Child" values for reporting (e.g., a "Total Assets" parent account summing up individual asset accounts). These relationships are defined using Rollup Groups and Hierarchies. Verifying that these groups are defined correctly and assigned to the right value sets is crucial for accurate financial consolidation and reporting.
This report provides a configuration audit of Rollup Groups. It allows administrators to:
- Identify which value sets have hierarchy structures enabled.
- Verify the names and codes of defined rollup groups.
- Ensure consistency in hierarchy definitions across different value sets.
The report joins fnd_flex_value_sets with fnd_flex_hierarchies_vl and fnd_flex_values to display the configuration of rollup groups.
- Flex Value Set: Filter by the specific value set (e.g., 'Operations Account').
- Rollup Group: Filter by a specific rollup group name.
This is a lightweight configuration report and typically runs very quickly.
Q: What is a Rollup Group? A: A Rollup Group is a tag used to identify a group of parent values in a value set. It allows you to perform summary reporting based on that level of the hierarchy.
Q: Does this report show the parent-child value assignments? A: No, this report shows the definition of the groups themselves. To see the actual hierarchy of values (which child belongs to which parent), use the FND Flex Value Hierarchy report.
- 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