Search Results segment_datatype

Overview

APPS.EDW_FLEX_SEG_MAPPINGS_V is an Oracle E-Business Suite view that exposes the metadata used by the Enterprise Data Warehouse (EDW) to map Oracle General Ledger key flexfield segments to their corresponding value sets and dimensional attributes. It is a thin projection over the underlying EDW_FLEX_SEG_MAPPINGS table and does not introduce any joins, filters, or transformations of its own. Because the view is owned by APPS and carries no documented base object dependencies beyond its parent table, it is best understood as a denormalized dictionary of flexfield configuration that reporting and integration layers can query without knowledge of the underlying flexfield application tables (FND_ID_FLEX_SEGMENTS, FND_FLEX_VALUE_SETS, FND_SEGMENT_ATTRIBUTE_VALUES, and related objects).

The view's principal value lies in the VALUE_SET_TYPE column, which records the validation type assigned to a segment's value set — for example Independent, Dependent, Table, or None. This is the attribute most frequently searched by implementers reconciling an EDW dimension back to its EBS source, since it determines whether a segment's values are drawn from a standalone value set or from a parent-child hierarchy.

Underlying Base Objects

ETRM documentation records no referenced base objects for this view other than the single table named in its defining SQL:

• EDW_FLEX_SEG_MAPPINGS — the sole source object. The view selects twenty-one columns from this table without predicates, aggregation, or joins.

Because EDW_FLEX_SEG_MAPPINGS is itself part of the EDW staging layer, it is populated from EBS flexfield definitions rather than being maintained transactionally. The view therefore inherits the refresh cadence of that staging table and should not be treated as a real-time representation of flexfield setup. No synonyms, grants, or alternate ownership are documented in the available metadata.

Key Columns

The projected columns fall into three functional groups.

• Structure identification: ID_FLEX_CODE, APPLICATION_ID, STRUCTURE_NUM, STRUCTURE_NAME, and DIMENSION_SHORT_NAME identify the key flexfield and the specific structure instance to which a segment belongs.
• Segment identification: SEGMENT_NAME, APPLICATION_COLUMN_NAME, FLEX_FIELD_TYPE, and FLEX_FIELD_NAME describe the segment itself and the underlying application column it maps to.
• Value set attributes: VALUE_SET_ID, VALUE_SET_NAME, VALUE_SET_TYPE, PARENT_VALUE_SET_ID, VALUE_SET_DATATYPE, and SEGMENT_DATATYPE describe the validation source for the segment. PARENT_VALUE_SET_ID is meaningful only when VALUE_SET_TYPE indicates a dependent value set.
• Audit columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN, plus INSTANCE_CODE for multi-instance or multi-org-aware extraction.

Common Use Cases and Queries

The most common requirement is identifying the validation type of the value set attached to each accounting flexfield segment, which the following query returns:

SELECT id_flex_code,
       structure_name,
       segment_name,
       value_set_name,
       value_set_type,
       parent_value_set_id
  FROM apps.edw_flex_seg_mappings_v
 WHERE value_set_type = 'D'
 ORDER BY id_flex_code, segment_name;

Analysts also use the view to reconcile EDW dimensions to EBS flexfield structures before building extract mappings, and to detect dependent value sets that require hierarchical loading of parent-child relationships. A further use is auditing data type alignment between the value set and the segment datatype prior to populating warehouse columns.