Search Results fnd_flex_vset_v




Overview
Explore in AI Chat

Overview

FND_FLEX_VSET_V is a reporting view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It belongs to the FND - Application Object Library product and exposes key flexfield value set metadata together with associated flex values and validation table attributes. The view is classified as VALID and is intended for read-only query and reporting access rather than for direct maintenance of flexfield configuration.

The view is particularly relevant to the search term summary_allowed_flag. That column is sourced from FND_FLEX_VALIDATION_TABLES and indicates whether a dependent or summary value set permits parent (summary) values that aggregate child values. The column is exposed directly as SUMMARY_ALLOWED_FLAG, allowing report authors and integrators to determine summary allowance without joining the underlying validation table manually.

Because FND_FLEX_VSET_V is a view, it does not store data itself. It consolidates configuration information from the key flexfield table family so that value set names, value identifiers, validation types, and summary rules can be retrieved in a single query.

Underlying Base Objects

The documented base objects referenced by the view are FND_FLEX_VALIDATION_TABLES, FND_FLEX_VALUES, FND_FLEX_VALUES_TL, and FND_FLEX_VALUE_SETS, each accessed through synonyms in the APPS schema. The view definition performs a union of two branches: one for value sets whose PARENT_FLEX_VALUE_SET_ID is null, and one for dependent value sets where a parent value set exists. Left outer joins preserve value sets that have no child values and values that have no translated description.

The FND_FLEX_VALUE_SETS table is aliased twice (V and V2) to resolve both the current value set and its parent. FND_FLEX_VALUES supplies the flex value and its enabled flag, while FND_FLEX_VALUES_TL supplies the language-specific description filtered by USERENV('LANG'). FND_FLEX_VALIDATION_TABLES supplies VALIDATION_TYPE and SUMMARY_ALLOWED_FLAG. Only enabled values (or values where ENABLED_FLAG is null, treated as 'Y' through NVL) are returned.

Key Columns

Common Use Cases and Queries

Typical use cases include auditing value set configuration, verifying summary allowance for reporting hierarchies, and joining flex values to transactional data for descriptive reporting. The following example lists value sets where summary values are allowed:

  • SELECT flex_value_set_name, flex_value, summary_allowed_flag FROM fnd_flex_vset_v WHERE summary_allowed_flag = 'Y';
  • SELECT flex_value_set_name, parent_value_set_name, flex_value FROM fnd_flex_vset_v WHERE parent_flex_value_set_id IS NOT NULL;
  • SELECT flex_value_set_id, validation_type, security_enabled_flag FROM fnd_flex_vset_v WHERE flex_value_set_name = :name;

These queries are read-only and suitable for custom reports, extracts, and integration validation logic against EBS 12.1.1 and 12.2.2.