FND Flex Values – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
Report for all flex values and the hierarchies they are included in. Column ‘Hierarchy Position’ can be used to validate your account hierarchy setup and check which account segment values are not included in any (or a specific) hierarchy yet.
In EBS R12.2., there is new flexfield value security in place, which would require the UMX|FND_FLEX_VSET_ALL_PRIVS_ROLE role to maintain flexfield values. If you do not have this role but apps DB access, you can add it from the backend:
begin wf_local_synch.propagateuserrole( p_user_name=>’ANDY.HAACK’, p_role_name=>’UMX|FND_FLEX_VSET_ALL_PRIVS_ROLE’ ); commit; end;
Report Parameters
Used by Key Flexfield, Used by Key Flex Structure, Flex Value Set, Independent Value, Flex Value like, Created By, Creation Date From, Creation Date To, Last Updated By, Last Update Date From, Last Update Date To, Active only, Missing in Hierarchy, Parent or Child, Parent Value like, Used in Rollup Group, Show DFF Attributes
Oracle EBS Tables Used
fnd_flex_value_norm_hierarchy, fnd_flex_value_sets, fnd_flex_values, fnd_flex_values_tl, fnd_flex_hierarchies_vl
Report Categories
Related Reports
FND Flex Value Upload, FND Flex Value Hierarchy, FND Rollup Groups, GL Account Analysis, GL Account Analysis (Distributions), GL Account Analysis 11g, GL Account Distribution Analysis
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 | FND Flex Values 03-Mar-2024 002021.xlsx |
| Blitz Report™ XML Import | FND_Flex_Values.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/fnd-flex-values/ |
Executive Summary
The FND Flex Values report is the standard master data report for segment values. It lists every value in an Independent or Dependent value set, along with its attributes and hierarchy status.
Business Challenge
- Master Data Management: Reviewing the list of active Cost Centers, Accounts, or Products.
- Hierarchy Maintenance: Identifying “Orphan” values that are missing from a parent hierarchy (using the “Missing in Hierarchy” parameter).
- Attribute Audit: Checking settings like “Allow Budgeting” or “Allow Posting” for GL accounts.
The Solution
This Blitz Report extracts the value definition:
- Value: The code and description.
- Status: Enabled/Disabled, Start/End Dates.
- Attributes: Segment qualifiers (Account Type, Reconcile, etc.).
- Hierarchy: Shows if the value is a Parent or Child and which Rollup Group it belongs to.
Technical Architecture
The report queries FND_FLEX_VALUES and FND_FLEX_VALUES_TL. It also checks FND_FLEX_VALUE_NORM_HIERARCHY to determine hierarchy status.
Parameters & Filtering
- Flex Value Set: The set to analyze (e.g., “Operations_Account”).
- Missing in Hierarchy: A critical filter for GL maintenance. It finds values that exist but are not rolled up to any parent.
- Active only: Filter out disabled values.
Performance & Optimization
- Volume: For very large charts of accounts, filter by a specific range or value set to keep the report manageable.
FAQ
- Q: How do I see the “Compiled” attributes?
- A: The report shows the raw attributes stored in
COMPILED_VALUE_ATTRIBUTES. These are often decoded into readable columns like “Account Type”.
- A: The report shows the raw attributes stored in
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