Search Results fnd_id_flex_segments

Overview

The FND_ID_FLEX_SEGMENTS table is a core repository for key flexfield segment definitions within Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. Residing in the APPLSYS schema under the Application Object Library (FND) module, it serves as the central table that defines the individual segments comprising a key flexfield structure. Its primary role is to store the setup information for each segment and to maintain the critical correspondence between a flexfield's logical segments and the physical database columns that store their values. This mapping is essential for the flexfield engine to correctly process, validate, and display data.

Key Information Stored

The table's design centers on uniquely identifying a segment within a specific flexfield structure and detailing its properties. The primary key (FND_ID_FLEX_SEGMENTS_PK) consists of APPLICATION_ID, ID_FLEX_CODE, ID_FLEX_NUM, and APPLICATION_COLUMN_NAME, which together pinpoint a specific segment column. Key columns include SEGMENT_NAME for the internal identifier, SEGMENT_NUM for display order, and FLEX_VALUE_SET_ID, which links the segment to its independent list of valid values. The APPLICATION_COLUMN_NAME is crucial, as it stores the name of the actual table column (e.g., SEGMENT1, SEGMENT2) that holds data for this segment. Additional columns control display characteristics, security, indexing, and required flags.

Common Use Cases and Queries

This table is fundamental for technical analysis, troubleshooting, and generating metadata reports for flexfields. A common use case is to retrieve the complete segment configuration for a specific flexfield, such as the Accounting Flexfield (GL#). Developers and administrators often query this table to understand segment-to-column mappings or to identify which value set is assigned to a segment. Sample queries include listing all segments for a structure or finding segments using a specific value set.

• Retrieve segment setup for the Accounting Flexfield:
  SELECT segment_name, segment_num, application_column_name, flex_value_set_id FROM fnd_id_flex_segments WHERE application_id = 101 AND id_flex_code = 'GL#' AND id_flex_num = 101 ORDER BY segment_num;
• Find all segments using a specific value set:
  SELECT a.application_id, a.id_flex_code, a.id_flex_num, a.segment_name FROM fnd_id_flex_segments a WHERE a.flex_value_set_id = &value_set_id;

Related Objects

As indicated by its foreign keys, FND_ID_FLEX_SEGMENTS has integral relationships with several other key flexfield tables. It is a child of FND_ID_FLEX_STRUCTURES, which defines the overall active structure. It references FND_FLEX_VALUE_SETS for validation. Key dependent objects that store additional data for each segment include FND_ID_FLEX_SEGMENTS_TL for translated segment prompts and FND_SEGMENT_ATTRIBUTE_VALUES for segment-level qualifiers. The table is also referenced by FND_FLEXBUILDER_PARAMETERS and FND_FLEX_VALIDATION_RULES, linking it to descriptive flexfield context-sensitive segments and cross-validation rules, respectively.