Search Results fact_short_name




Overview
Explore in AI Chat

Overview

APPS.EDW_FACT_FLEX_FK_MAPS_V is a reporting and integration view in the Oracle E-Business Suite (EBS) Enterprise Data Warehouse (EDW) / Enterprise Technical Reference Model (ETRM) layer. It exposes the foreign-key linkage between descriptive flexfield segments used on fact tables and the dimension members that those segments resolve to in the dimensional model. In practice, the view maps a fact-side segment (identified by its physical column name) to the dimension that supplies the corresponding key, enabling the ETL and BI layers to translate flexfield-based attributes into conformed dimension joins.

Because it is a thin projection over a single EDW control table, the view does not itself aggregate or transform business data. Its role is to publish metadata that drives downstream star-schema construction, allowing fact tables to be joined to their dimensions through flexfield segment logic rather than hard-coded column relationships.

Underlying Base Objects

The documented metadata indicates the view is defined solely over the base table EDW_FACT_FLEX_FK_MAPS. The view text is a straightforward column-selective projection of that table:

The absence of a WHERE clause means the view returns enabled and disabled mapping rows alike, unless the consumer restricts them explicitly.

Key Columns

The columns expose the mapping definition and its auditing metadata:

  • FACT_SHORT_NAME — The short name identifying the EDW fact (star) that owns the flexfield foreign-key relationship.
  • FK_PHYSICAL_NAME — The physical column name on the fact table that carries the flexfield segment or foreign-key value.
  • DIMENSION_SHORT_NAME — The short name of the dimension to which that physical column maps.
  • ENABLED_FLAG — Indicates whether the mapping is currently active; typically 'Y' for enabled and 'N' for disabled.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard EBS audit columns recording the most recent change and the responsible user/session.
  • CREATED_BY, CREATION_DATE — Standard EBS creation audit columns.

Common Use Cases and Queries

The view is typically queried to discover how fact columns relate to dimensions, to filter only active mappings, or to reconcile EDW metadata during implementation and upgrade cycles. A representative query retrieving the mapping context for a given fact is:

  • SELECT fact_short_name, fk_physical_name, dimension_short_name FROM apps.edw_fact_flex_fk_maps_v WHERE fact_short_name = :fact_short_name AND enabled_flag = 'Y';
  • SELECT * FROM apps.edw_fact_flex_fk_maps_v WHERE dimension_short_name = :dimension_short_name;

Consumers should note that the view applies no inherent restriction to enabled rows, so an explicit ENABLED_FLAG filter is recommended when constructing dimension joins for reporting or ETL. The base table underlying the view is schema-qualified as APPS and is documented as part of the ETRM metadata set for 12.1.1 and 12.2.2.