Search Results dep_value_set_name

Overview

FND_FLEX_VSET_V is a seed data dictionary view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It is registered as a dependency of the FND design data component (FND.FND_FLEX_VSET_V) and carries a status of VALID. The view consolidates descriptive metadata about Oracle Flexfield value sets, both the dependent ("child") value set and its parent, together with the individual values and their descriptions. Its primary purpose is to expose value set names, IDs, and descriptions alongside the values contained within those sets, which makes it useful for reporting on flexfield configuration and for integration scenarios that must resolve a value set or value to a human-readable description.

The Oracle ETRM documentation explicitly flags this object with a warning that it is for Oracle Internal Use Only and that Oracle Corporation does not support access to application data using this object except from standard Oracle Applications programs. Consequently, the view should be treated as an internal, non-supported interface; custom code that queries it directly assumes the risk of future change. The column list includes DEP_VALUE_SET_ID and DEP_VALUE_SET_DESCRIPTION in the referenced metadata, meaning queries that filter or project on the user search term "dep_value_set_description" will find the matching column DEP_VALUE_SET_DESCRIPTION directly on this view.

Underlying Base Objects

FND_FLEX_VSET_V is defined over four synonym-referenced base tables in the APPS schema: FND_FLEX_VALIDATION_TABLES, FND_FLEX_VALUES, FND_FLEX_VALUES_TL, and FND_FLEX_VALUE_SETS. FND_FLEX_VALUE_SETS holds the definition of each value set, including its name, ID, description, validation type, and security and summary flags. FND_FLEX_VALUES stores the actual values belonging to a value set, while FND_FLEX_VALUES_TL stores the translated value descriptions in the language-specific (_TL) table. FND_FLEX_VALIDATION_TABLES is the validation association table that joins a value set to the tables or columns it validates. The views joins these sources to present a flattened row per value that also carries the parent and dependent value set identity and descriptions.

Key Columns

• DEP_VALUE_SET_NAME / DEP_VALUE_SET_ID / DEP_VALUE_SET_DESCRIPTION — the dependent value set's name, internal identifier, and description (up to 240 characters).
• PARENT_VALUE_SET_NAME / PARENT_FLEX_VALUE_SET_ID / PARENT_VALUE_SET_DESCRIPTION — the parent value set identity and description used in dependent value set hierarchies.
• FLEX_VALUE_SET_ID — the value set identifier associated with the row.
• SECURITY_ENABLED_FLAG — indicates whether value set security is enabled.
• FLEX_VALUE / VALUE_DESCRIPTION — the individual flexfield value and its translated description.
• VALIDATION_TYPE / SUMMARY_ALLOWED_FLAG — the validation method (for example, independent, dependent, table, or none) and whether summary values are permitted.

Common Use Cases and Queries

The view is most often used to report on value set definitions and to resolve values to descriptions when diagnosing flexfield setup.

SELECT dep_value_set_name
     , dep_value_set_id
     , dep_value_set_description
     , parent_value_set_name
     , flex_value
     , value_description
  FROM apps.fnd_flex_vset_v
 WHERE dep_value_set_description LIKE :description;

A typical integration scenario joins the view to a staging table on DEP_VALUE_SET_ID or PARENT_FLEX_VALUE_SET_ID to enrich imported values with their descriptive text. Because Oracle does not support direct access, such usage should be confined to diagnostic or read-only reporting and validated against each environment on 12.1.1 and 12.2.2.