Search Results fnd_value_attribute_types




Overview
Explore in AI Chat

Overview

The FND_VALUE_ATTRIBUTE_TYPES table is a core repository table within the Application Object Library (FND) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It serves as a definitional table for key flexfield segment qualifiers. In essence, it defines the specific types of value-level attributes that can be assigned to individual segment values within a key flexfield structure. This table enables the creation of sophisticated validation and descriptive rules that apply directly to the data entered into a flexfield segment, extending the functionality beyond the basic segment definition. Its role is critical for implementing complex business rules and data governance at the most granular level of a flexfield.

Key Information Stored

The table's primary key uniquely identifies each value attribute type definition and consists of four columns: APPLICATION_ID, ID_FLEX_CODE, SEGMENT_ATTRIBUTE_TYPE, and VALUE_ATTRIBUTE_TYPE. The APPLICATION_ID and ID_FLEX_CODE columns link the attribute to a specific key flexfield (e.g., Accounting Flexfield). The SEGMENT_ATTRIBUTE_TYPE references a broader category of segment attribute from the FND_SEGMENT_ATTRIBUTE_TYPES table. The VALUE_ATTRIBUTE_TYPE is the specific qualifier name defined for use at the value level. For example, for a segment attribute type of "GL Account", a value attribute type could be "Posting Allowed" or "Budget Allowed". This structure allows a single segment attribute type to have multiple, specific value-level qualifiers.

Common Use Cases and Queries

A primary use case is to audit or report on the configured validation rules for key flexfields, particularly during system upgrades or migrations. Developers and functional consultants query this table to understand the available qualifiers for a given flexfield segment when building custom integrations or extensions. A common query pattern involves joining to the FND_SEGMENT_ATTRIBUTE_TYPES table to get a complete description. For example, to list all value attribute types for the Accounting Flexfield (ID_FLEX_CODE='GL#'):

  • SELECT vs.*, sat.segment_attribute_type_name
  • FROM fnd_value_attribute_types vs,
  • fnd_segment_attribute_types_tl sat
  • WHERE vs.application_id = sat.application_id
  • AND vs.id_flex_code = sat.id_flex_code
  • AND vs.segment_attribute_type = sat.segment_attribute_type
  • AND vs.id_flex_code = 'GL#'
  • AND sat.language = USERENV('LANG');

Related Objects

FND_VALUE_ATTRIBUTE_TYPES is centrally linked to several other key flexfield metadata tables, as documented by its foreign key relationships. It is a child of FND_SEGMENT_ATTRIBUTE_TYPES, inheriting the broader attribute category. It is a parent to two important tables: FND_FLEX_VALIDATION_QUALIFIERS, which stores the actual "Yes/No" or specific value for these qualifiers at the individual segment value level, and FND_VAL_ATTRIBUTE_TYPES_TL, which holds the translated names (TL) for the VALUE_ATTRIBUTE_TYPE. The join columns for these relationships consistently use the composite key of APPLICATION_ID, ID_FLEX_CODE, SEGMENT_ATTRIBUTE_TYPE, and VALUE_ATTRIBUTE_TYPE.