Results for “segment_attribute_type”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

FND_FLEX_VALIDATION_QUALIFIERS is a reference and assignment table in the APPLSYS schema of Oracle E-Business Suite, owned by the FND – Application Object Library product. Its documented purpose is to hold assignment information for flexfield qualifiers. In the Oracle EBS key flexfield and descriptive flexfield architecture, a flex value set defines the pool of valid values that may be entered for a segment, while qualifiers determine which structural attributes apply to those values for a specific combination of application, key flexfield code, and segment. This table records that assignment so that validation behavior, segment attribute semantics, and value attribute semantics remain consistent across the applications that share a given value set.

Within the documented FDI Data Vault classification (a heuristic mined from the foreign key structure), this object is characterized as a link. That classification is a modeling suggestion: the table resolves a many-to-many style association among value sets, flexfield definitions, and attribute type definitions rather than acting as a standalone hub of business entities. Its composite primary key, FND_FLEX_VALIDATION_QUALS_PK, reflects that associative role directly.

Key Information Stored

The physical schema documented for 12.2.2 contains seven columns for this object. The columns carrying the substantive business meaning are:

• FLEX_VALUE_SET_ID — identifies the flex value set to which the qualifier assignment applies; part of the primary key and the first component of the unique index.
• ID_FLEX_APPLICATION_ID — the application owning the key flexfield definition; also part of the primary key.
• ID_FLEX_CODE — the key flexfield code that, combined with the application, identifies the flexfield definition; part of the primary key.
• SEGMENT_ATTRIBUTE_TYPE — the segment-level attribute type being qualified; part of the primary key.
• VALUE_ATTRIBUTE_TYPE — the value-level attribute type being qualified; part of the primary key.
• ASSIGNMENT_DATE — records when the qualifier assignment was made, providing an audit trail for the association.
• ZD_EDITION_NAME — the edition name used for the edition-based redefinition scheme in 12.2.x, supporting online patching and non-destructive upgrades.

The surrogate composite primary key is FND_FLEX_VALIDATION_QUALS_PK, defined over (FLEX_VALUE_SET_ID, ID_FLEX_APPLICATION_ID, ID_FLEX_CODE, SEGMENT_ATTRIBUTE_TYPE, VALUE_ATTRIBUTE_TYPE). A second unique index, FND_FLEX_VALIDATION_QUALS_U1, carries the same five business columns plus ZD_EDITION_NAME. The business-key candidate is therefore the combination of value set, application, flexfield code, segment attribute type, and value attribute type; ZD_EDITION_NAME extends this for the multi-edition model rather than representing independent business data.

Common Use Cases and Queries

Typical usage centers on flexfield configuration queries and diagnostic reporting. Administrators and support analysts join this table to FND_FLEX_VALUE_SETS to determine which value sets carry qualifier assignments within a given flexfield, and to FND_VALUE_ATTRIBUTE_TYPES to resolve the attribute type meanings. The user query term id_flex_application_id is a frequently filtered column because reporting usually scopes results to a single application and flexfield code.

• Locating all qualifier assignments for a value set: SELECT id_flex_application_id, id_flex_code, segment_attribute_type, value_attribute_type FROM fnd_flex_validation_qualifiers WHERE flex_value_set_id = :value_set_id;
• Reporting by application and flexfield: filter on ID_FLEX_APPLICATION_ID and ID_FLEX_CODE to produce configuration inventories for change management.
• Audit reporting: select ASSIGNMENT_DATE to trace when qualifier assignments were established.
• Edition-aware queries in 12.2.x should constrain ZD_EDITION_NAME to the active edition to avoid returning rows from other editions.

Related Objects

The documented foreign key relationships anchor this object to the core flexfield dictionaries:

• FND_FLEX_VALUE_SETS — joined on FLEX_VALUE_SET_ID; supplies the value set definition and is the parent for the value-set dimension of the assignment.
• FND_VALUE_ATTRIBUTE_TYPES — joined on ID_FLEX_APPLICATION_ID (per the documented FK); supplies the attribute type definition for the assignment.
• Depending on the flexfield being examined, related objects such as FND_ID_FLEX_SEGMENTS and FND_ID_FLEX_STRUCTURES are commonly used alongside this table to place the qualifier assignment in the context of a segment and structure.

Because the table is an associative link in the documented classification, its principal value lies in joining the value set, the flexfield definition, and the attribute type definitions together rather than in storing descriptive attributes of its own.