| layout | default |
|---|---|
| title | FND Flex Value Upload | Oracle EBS SQL Report |
| description | Upload to create or update flex values for Independent, Dependent, Translatable Independent, and Translatable Dependent value sets. Supports: - Value… |
| keywords | Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, Upload, FND, Flex, Value, fnd_flex_value_sets, fnd_flex_values, fnd_flex_values_tl |
| permalink | /FND%20Flex%20Value%20Upload/ |
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
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.
Upload Mode, Flex Value Set, Flex Value Like, Independent Value
fnd_flex_value_sets, fnd_flex_values, fnd_flex_values_tl, fnd_flex_hierarchies_vl, fnd_flex_value_norm_hierarchy
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
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 | None |
| Blitz Report™ XML Import | FND_Flex_Value_Upload.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/fnd-flex-value-upload/ |
- 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