Search Results fnd_flex_value_sets_pk

Overview

FND_FLEX_VALUE_SETS is a core Application Object Library (FND) table in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the definition of value sets used by both key flexfields and descriptive flexfields across all EBS products. A value set defines the pool of valid values that a flexfield segment, descriptive flexfield attribute, or concurrent program parameter can accept. Because almost every validation in the E-Business Suite ultimately resolves to a value set, this table is a foundational reference object that governs data entry, validation, and reporting logic throughout the application.

The table resides in the APPLSYS schema and is documented with 24 columns. Based on the mined foreign-key structure, FND_FLEX_VALUE_SETS is best modeled as a Data Vault hub: it holds the durable business key (the value set identity) around which numerous dependent and referencing entities cluster. It carries a self-referencing relationship through PARENT_FLEX_VALUE_SET_ID, and it is referenced by dozens of tables spanning FND, GL, IBC, WMS, and ZX modules.

Key Information Stored

The following columns are the most functionally significant:

• FLEX_VALUE_SET_ID — The surrogate primary key (FND_FLEX_VALUE_SETS_PK). All dependent tables join on this column.
• FLEX_VALUE_SET_NAME — The business-key name of the value set, unique per edition (FND_FLEX_VALUE_SETS_U2). This is the identifier users select in the flexfield and value set definition forms.
• VALIDATION_TYPE — Defines how values are validated: independent, dependent, table, translatable independent, or specialized (e.g., none, pairwise). This drives the validation path at runtime.
• FORMAT_TYPE — Specifies the format of acceptable values, such as character, number, date, or time.
• MAXIMUM_SIZE — The maximum length of values the set will accept.
• ALPHANUMERIC_ALLOWED_FLAG, UPPERCASE_ONLY_FLAG, NUMERIC_MODE_ENABLED_FLAG — Character-formatting and validation flags controlling what input the set permits.
• NUMBER_PRECISION, MINIMUM_VALUE, MAXIMUM_VALUE — Numeric range and precision constraints when the format type is numeric.
• SECURITY_ENABLED_FLAG — Indicates whether value-level security is enforced, restricting users to a subset of values.
• PROTECTED_FLAG — Marks value sets protected from modification.
• LONGLIST_FLAG — Controls whether the value list is presented as a long list of values.
• PARENT_FLEX_VALUE_SET_ID — Self-referencing foreign key that links a dependent value set to its parent value set.
• DEPENDANT_DEFAULT_VALUE and DEPENDANT_DEFAULT_MEANING — Default dependent values used during dependent value set validation.
• DESCRIPTION — Free-text description of the value set.
• ZD_EDITION_NAME — Editioning column supporting Online Patching (ADOP) in 12.2.x, distinguishing edition-specific rows.

Standard audit columns (LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN) are also present. Business-key candidates are FLEX_VALUE_SET_ID with ZD_EDITION_NAME (U1) and FLEX_VALUE_SET_NAME with ZD_EDITION_NAME (U2).

Common Use Cases and Queries

A frequent requirement is to resolve the value set assigned to a particular flexfield segment or descriptive flexfield column. The following pattern joins FND_FLEX_VALUE_SETS to FND_ID_FLEX_SEGMENTS:

• Segment-to-value-set lookup: SELECT s.segment_name, vs.flex_value_set_name, vs.validation_type FROM fnd_id_flex_segments s, fnd_flex_value_sets vs WHERE s.flex_value_set_id = vs.flex_value_set_id AND s.id_flex_num = :flex_num.
• Inventory of independent value sets: SELECT flex_value_set_name FROM fnd_flex_value_sets WHERE validation_type = 'I'.
• Locating security-enabled sets: SELECT flex_value_set_name, security_enabled_flag FROM fnd_flex_value_sets WHERE security_enabled_flag = 'Y'.
• Impact analysis for changes: Join to FND_FLEX_VALUES and FND_FLEX_VALUE_HIERARCHIES to assess downstream impact before modifying a value set.
• Audit reporting: Query LAST_UPDATE_DATE and LAST_UPDATED_BY to identify recently modified value set definitions.

Reporting on value set configuration is valuable ahead of upgrades, when effecting flexfield changes, or when diagnosing validation errors in data conversion and interface programs.

Related Objects

FND_FLEX_VALUE_SETS is referenced broadly. The most significant dependent objects include:

• FND_FLEX_VALUES (FLEX_VALUE_SET_ID) — The individual values belonging to each value set.
• FND_ID_FLEX_SEGMENTS (FLEX_VALUE_SET_ID) — Key flexfield segments that use the value set.
• FND_DESCR_FLEX_COLUMN_USAGES (FLEX_VALUE_SET_ID) — Descriptive flexfield columns that use the value set.
• FND_FLEX_VALUE_HIERARCHIES and FND_FLEX_VALUE_NORM_HIERARCHY (FLEX_VALUE_SET_ID) — Hierarchy definitions for rollup and reporting value sets.
• FND_FLEX_HIERARCHIES (FLEX_VALUE_SET_ID) — Flexfield hierarchy metadata.
• FND_FLEX_VALIDATION_TABLES, FND_FLEX_VALIDATION_EVENTS, and FND_FLEX_VALIDATION_QUALIFIERS (FLEX_VALUE_SET_ID) — Validation configuration for table-validated value sets.
• FND_FLEX_VALUE_RULES, FND_FLEX_VALUE_RULE_LINES, and FND_FLEX_VALUE_RULE_USAGES (FLEX_VALUE_SET_ID) — Security and rule-based value restrictions.
• GL_CONS_SEGMENT_MAP (FROM_VALUE_SET_ID, TO_VALUE_SET_ID) — Consolidation segment mapping.
• FND_FLEXBUILDER_PARAMETERS (FLEX_VALUE_SET_ID, ASSIGNMENT_VALUE_SET_ID) — Flexbuilder configuration.

These relationships confirm the hub role of FND_FLEX_VALUE_SETS and demonstrate why it is a critical reference point whenever flexfield validation logic is analyzed or modified.