FND Flex Value Upload – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
Upload to create or update flex values for Independent, Dependent, Translatable Independent, and Translatable Dependent value sets.
Supports:
- Value creation and update (auto-detects via fnd_flex_values_pkg.load_row upsert)
- Enabled flag, start/end dates
- Summary flag (parent/child designation)
- Rollup group assignment for parent values
- Compiled value attributes (qualifier values for KFF segments, e.g. GL Account Type, Allow Posting)
- Hierarchy level
- Attribute sort order
- DFF attributes (ATTRIBUTE1..50)
- Translatable value meaning and description (for Translatable Independent/Dependent value sets)
Note: After uploading parent values with hierarchy changes, run the ‘Compile Value Hierarchy’ concurrent program from the Value Sets form to update the compiled hierarchy.
Report Parameters
Upload Mode, Flex Value Set, Flex Value Like, Independent Value
Oracle EBS Tables Used
fnd_flex_value_sets, fnd_flex_values, fnd_flex_values_tl, fnd_flex_hierarchies_vl, fnd_flex_value_norm_hierarchy
Report Categories
Related Reports
FND Flex Values, 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 | None |
| Blitz Report™ XML Import | FND_Flex_Value_Upload.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/fnd-flex-value-upload/ |
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