Search Results fnd_flex_value_sets_u1

Overview

APPLSYS.FND_FLEX_VALUE_SETS is an Oracle E-Business Suite foundation table that stores the definition of every value set used by both key and descriptive flexfields. A value set establishes the container, validation rules, format, size, and security behavior for the set of valid values that a flexfield segment or report parameter may accept. Oracle Application Object Library (AOL) reads rows from this table to determine how to validate user entry, how to render the list of values (LOV), and how to enforce range or hierarchy constraints.

In Data Vault modeling terms, the ETRM heuristic classifies this object as a hub. It is the authoritative registry of value set identity, uniquely identified by FLEX_VALUE_SET_ID through the primary key constraint FND_FLEX_VALUE_SETS_PK. Related satellites and links (values, hierarchies, validation rules, segment assignments) reference this hub rather than duplicate value set definition attributes. Rows describe the value set itself; the actual valid values reside in FND_FLEX_VALUES.

Key Information Stored

The table contains 24 documented columns. The most consequential for functional and technical work are:

• FLEX_VALUE_SET_ID — surrogate primary key; the unique numeric identifier for each value set. Referenced by a large majority of dependent objects.
• FLEX_VALUE_SET_NAME — the user-visible name of the value set. Together with ZD_EDITION_NAME it forms business-key candidate FND_FLEX_VALUE_SETS_U2.
• VALIDATION_TYPE — the validation mechanism: F (Table), I (Independent), D (Dependent), N (None), P (Pair), or U (Special). This governs how values are resolved and matched.
• FORMAT_TYPE — data format (Char, Number, Date, DateTime) that controls accepted input.
• MAXIMUM_SIZE and MINIMUM_VALUE/MAXIMUM_VALUE — size and numeric range boundaries; NUMBER_PRECISION holds precision for number format sets.
• ALPHANUMERIC_ALLOWED_FLAG, UPPERCASE_ONLY_FLAG, NUMERIC_MODE_ENABLED_FLAG — character and formatting constraints applied at entry.
• SECURITY_ENABLED_FLAG and LONGLIST_FLAG — control flexfield value security and the LOV LongList feature.
• PARENT_FLEX_VALUE_SET_ID — self-referencing FK identifying the independent value set on which a dependent value set relies.
• DEPENDANT_DEFAULT_VALUE and DEPENDANT_DEFAULT_MEANING — defaults auto-created in a dependent set when a new independent value is added.
• ZD_EDITION_NAME — editioning attribute present in 12.2.x online patching; compounds both unique indexes.
• Standard audit columns CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN.

Note that two unique indexes exist: FND_FLEX_VALUE_SETS_U1 on FLEX_VALUE_SET_ID, ZD_EDITION_NAME and FND_FLEX_VALUE_SETS_U2 on FLEX_VALUE_SET_NAME, ZD_EDITION_NAME. The user's search term, fnd_flex_value_sets_u2, corresponds to the unique business-key index enforcing uniqueness of the value set name within an edition.

Common Use Cases and Queries

Typical scenarios include locating the value set behind a flexfield segment, auditing validation types across an instance, and tracing dependent set relationships.

• Identify the value set used by a segment: join FND_ID_FLEX_SEGMENTS.FLEX_VALUE_SET_ID to this table.
• Audit security-enabled or LongList-enabled sets.
• Trace dependent-to-independent lineage via PARENT_FLEX_VALUE_SET_ID.

Representative query:

SELECT v.FLEX_VALUE_SET_ID,
       v.FLEX_VALUE_SET_NAME,
       v.VALIDATION_TYPE,
       v.FORMAT_TYPE,
       v.MAXIMUM_SIZE,
       v.SECURITY_ENABLED_FLAG
FROM   APPLSYS.FND_FLEX_VALUE_SETS v
WHERE  v.FLEX_VALUE_SET_NAME LIKE 'XX%'
ORDER  BY v.FLEX_VALUE_SET_NAME;

A dependent-set traversal joins the table to itself on PARENT_FLEX_VALUE_SET_ID = FLEX_VALUE_SET_ID. Reporting on value set usage across flexfields typically joins FND_ID_FLEX_SEGMENTS and FND_DESCR_FLEX_COLUMN_USAGES.

Related Objects

The hub is referenced by numerous downstream objects. The most significant include:

• FND_FLEX_VALUES.FLEX_VALUE_SET_ID — the actual valid value rows belonging to each set.
• FND_ID_FLEX_SEGMENTS.FLEX_VALUE_SET_ID — links value sets to key flexfield segments.
• FND_DESCR_FLEX_COLUMN_USAGES.FLEX_VALUE_SET_ID — associates value sets with descriptive flexfield columns.
• FND_FLEX_VALUE_RULES.FLEX_VALUE_SET_ID and FND_FLEX_VALUE_RULE_LINES.FLEX_VALUE_SET_ID — security rule definitions.
• FND_FLEX_VALIDATION_TABLES, FND_FLEX_VALIDATION_EVENTS, FND_FLEX_VALIDATION_QUALIFIERS — validation configuration for table-validated sets.
• FND_FLEX_HIERARCHIES.FLEX_VALUE_SET_ID and FND_FLEX_VALUE_HIERARCHIES.FLEX_VALUE_SET_ID — hierarchy definitions.
• GL_LEDGERS.BAL_SEG_COLUMN_NAME / MGT_SEG_COLUMN_NAME and GL_LE_VALUE_SETS.FLEX_VALUE_SET_ID — General Ledger usage in 12.1.1 and 12.2.2.
• Self-reference on PARENT_FLEX_VALUE_SET_ID for dependent value sets.

These relationships confirm the table's position as the central definition hub for flexfield value validation across the EBS data model.