Search Results fnd_flex_value_sets

Overview

The FND_FLEX_VALUE_SETS table is a core repository within the Application Object Library (FND) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It serves as the master definition table for all value sets, which are foundational components for both Key Flexfields (KFFs) and Descriptive Flexfields (DFFs). A value set defines the list of valid values, validation rules, and formatting for a segment within a flexfield. Every segment in a flexfield must be associated with a value set, making this table critical for ensuring data integrity and consistency across the application's customizable data structures. The table is owned by the APPLSYS schema and is central to the flexfield architecture.

Key Information Stored

The table stores metadata that governs the behavior and validation of flexfield segment values. Its primary key is FLEX_VALUE_SET_ID, a unique numeric identifier. The FLEX_VALUE_SET_NAME column provides a unique, user-defined name for the value set, which is enforced by a separate unique key constraint. Other significant columns define the value set's characteristics: VALIDATION_TYPE (e.g., Independent, Dependent, Table, None), FORMAT_TYPE (e.g., Char, Date, Number), MAXIMUM_SIZE, and PROTECTED_FLAG. The table also supports hierarchical relationships between value sets through the PARENT_FLEX_VALUE_SET_ID column, which is a self-referencing foreign key to the same table. This structure allows for the creation of dependent value sets where the list of valid values in one set is contingent upon the value selected in another.

Common Use Cases and Queries

This table is frequently queried for flexfield configuration analysis, troubleshooting, and reporting. Common scenarios include identifying all value sets used in the system, diagnosing invalid segment value errors, and understanding dependencies between flexfield segments. A fundamental query retrieves basic value set definitions:

• SELECT flex_value_set_name, validation_type, format_type, maximum_size FROM fnd_flex_value_sets WHERE flex_value_set_name LIKE '<Pattern>';

To find which descriptive flexfield contexts use a specific value set, one would join with FND_DESCR_FLEX_COLUMN_USAGES. Another critical use case is querying the hierarchical parent-child relationships between value sets to map dependent validations:

• SELECT child.flex_value_set_name AS child_set, parent.flex_value_set_name AS parent_set FROM fnd_flex_value_sets child LEFT JOIN fnd_flex_value_sets parent ON child.parent_flex_value_set_id = parent.flex_value_set_id;

Related Objects

As indicated by its extensive foreign key relationships, FND_FLEX_VALUE_SETS is the central hub for numerous flexfield-related entities. Key dependent tables include FND_FLEX_VALUES and FND_FLEX_VALUE_HIERARCHIES, which store the actual valid values and their hierarchical structures. It is referenced by flexfield definition tables such as FND_ID_FLEX_SEGMENTS (for key flexfield segments) and FND_DESCR_FLEX_COLUMN_USAGES (for descriptive flexfield segments). The table also links to advanced validation objects like FND_FLEX_VALIDATION_TABLES, FND_FLEX_VALUE_RULES, and FND_FLEX_HIERARCHIES. This network of relationships underscores its essential role in the EBS flexfield framework.