Search Results fnd_segment_attribute_types

Overview

The FND_SEGMENT_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 the master definition table for key flexfield qualifiers. A qualifier is a specific type of attribute that can be assigned to a key flexfield segment to control its behavior or define its purpose, such as designating a segment as a "Cost Center" or "Natural Account." This table defines the universe of possible segment attribute types that can be applied to key flexfields across the entire EBS installation, establishing a critical link between a flexfield structure and the specific business attributes of its segments.

Key Information Stored

The table's structure centers on uniquely identifying a segment attribute type within the context of a specific key flexfield. Its primary key columns are APPLICATION_ID, ID_FLEX_CODE, and SEGMENT_ATTRIBUTE_TYPE. The APPLICATION_ID and ID_FLEX_CODE columns foreign key to the FND_ID_FLEXS table, thereby tying the attribute type definition to a particular flexfield, such as the Accounting Flexfield (GL#) or the Item Categories Flexfield (MCAT). The SEGMENT_ATTRIBUTE_TYPE column stores the internal name of the qualifier. While the provided ETRM excerpt does not list all columns, typical columns in this table include DISPLAY_NAME, DESCRIPTION, and ENABLED_FLAG, which control the presentation and active status of the qualifier within the flexfield definition forms.

Common Use Cases and Queries

This table is primarily queried for flexfield configuration analysis, troubleshooting, and impact assessment. A common use case is to identify all defined qualifiers for a specific key flexfield. For example, to list all segment attribute types for the Accounting Flexfield, a developer or analyst might execute:

• SELECT segment_attribute_type, display_name FROM apps.fnd_segment_attribute_types WHERE application_id = 101 AND id_flex_code = 'GL#' ORDER BY segment_attribute_type;

Another critical scenario involves validating or auditing flexfield configurations before a migration or upgrade. Queries joining this table to FND_SEGMENT_ATTRIBUTE_VALUES can reveal which specific segments in which flexfield structures have been assigned a particular qualifier, providing a complete map of attribute usage across the system.

Related Objects

As documented in the ETRM metadata, FND_SEGMENT_ATTRIBUTE_TYPES maintains integral relationships with several other FND tables. It is the parent table for FND_SEGMENT_ATTRIBUTE_VALUES, which stores the actual assignment of a qualifier to a specific segment in a specific flexfield structure. It also relates to FND_FLEXBUILDER_PARAMETERS, which may store additional configuration parameters for the attribute type. Furthermore, it is referenced by FND_VALUE_ATTRIBUTE_TYPES, a table involved in defining value-specific attributes that depend on the segment qualifier. The primary foreign key relationship is with FND_ID_FLEXS (on APPLICATION_ID, ID_FLEX_CODE), which is the master definition table for the key flexfield itself.