FND Flex Value Sets, Usages and Values – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
Value sets and values including usages, validation type, format type, validation table, columns etc.
Report Parameters
Flex Value Set Name like, Show LOV Query, Show Usages, Show Values, Validation Type, Table Name, Last Update Date From
Oracle EBS Tables Used
fnd_flex_value_sets, fnd_flex_validation_tables, fnd_application_vl, fnd_flex_values_vl, fnd_descr_flex_col_usage_vl, fnd_descriptive_flexs_vl, fnd_id_flex_segments_vl, fnd_id_flex_structures_vl, fnd_id_flexs, fnd_concurrent_programs_vl
Report Categories
Related Reports
FND Descriptive Flexfields, FND Key Flexfields, FND Concurrent Programs and Executables 11i, FND Concurrent Programs and Executables, FND Flex Value Security Rules, PER Organizations, AP Invoice Upload, GL Account Upload
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 Value Sets, Usages and Values 20-Jan-2019 123359.xlsx |
| Blitz Report™ XML Import | FND_Flex_Value_Sets_Usages_and_Values.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/fnd-flex-value-sets-usages-and-values/ |
Executive Summary
The FND Flex Value Sets, Usages and Values report is a comprehensive dictionary of all value sets in the system. It documents not just the list of values, but where the value set is used (DFFs, Key Flexfields, Concurrent Programs).
Business Challenge
- Impact Analysis: Before changing a value set (e.g., adding a value or changing validation), knowing every report and screen that uses it.
- Cleanup: Identifying unused value sets.
- Standardization: Finding duplicate value sets that could be consolidated.
The Solution
This Blitz Report provides a 360-degree view:
- Definition: Validation type (Independent, Table, None), Format, and Maximum Size.
- Content: Can list the actual values contained in the set.
- Usage: Lists every DFF Segment, Key Flexfield Segment, and Concurrent Program Parameter that references this value set.
Technical Architecture
The report joins FND_FLEX_VALUE_SETS with FND_DESCR_FLEX_COL_USAGE, FND_ID_FLEX_SEGMENTS, and FND_CONCURRENT_PROGRAMS.
Parameters & Filtering
- Flex Value Set Name: Search for a specific set.
- Show Usages: Toggle to see the “Where Used” analysis.
- Show Values: Toggle to see the list of values (careful with large sets like GL Accounts).
Performance & Optimization
- Large Sets: Do not use “Show Values” for large table-validated sets (like Suppliers or Customers) as it will try to dump the entire table.
FAQ
- Q: Can I see the SQL for table-validated sets?
- A: Yes, enable “Show LOV Query” to see the exact SQL used to populate the list.
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