Search Results locator_fk




Overview
Explore in AI Chat

Overview

APPS.OPI_EDW_OPI_RES_UTIL_FCV is an Oracle E-Business Suite view that serves as a flattened, load-ready feeder for the Oracle Process Manufacturing (OPM) resource utilization subject area within the Enterprise Data Warehouse (EDW). The suffix "FCV" denotes a "flat change view" pattern commonly used in the Oracle EBS EDW integration layer, where dimensional foreign keys are pre-computed and cast into a denormalized, string-based surrogate format suitable for downstream extraction, transformation, and load (ETL) processing.

Rather than presenting normalized OPM transactional columns, the view synthesizes composite key strings for resource utilization records, plant locators, resources, time, unit of measure, and instance context. In the context of Oracle EBS 12.1.1 and 12.2.2, this view falls within the OPI (Oracle Process Industries) EDW schema and is exposed to the APPS synonym layer for reporting and integration consumption. It is not a user-facing transactional view; it is intended for the EDW staging and dimensional conforming process.

Underlying Base Objects

The documented view text references two base objects:

The view is a simple Cartesian join with no documented WHERE clause, meaning every instance row is paired with every push log row. No additional base objects are documented in the ETRM metadata. The EDW_TIME_PKG.CAL_DAY_FK function is invoked to derive the calendar day foreign key.

Key Columns

  • RES_UTIL_PK — Concatenation of RES_UTIL_PK, instance code, and the literal suffix "-OPI"; uniquely identifies the resource utilization fact.
  • LOCATOR_FK — Composed as ORGANIZATION_CODE || '-' || INSTANCE_CODE || '-PLNT'. This is the column referenced by the "locator_fk" search term; it represents the plant/organization locator dimension key.
  • RES_FK — Composite of resource, department, organization, and instance codes, identifying the resource dimension.
  • TRX_DATE_FK — Derived via EDW_TIME_PKG.CAL_DAY_FK(TRX_DATE, SOB_ID, INSTANCE_CODE); the calendar day dimension key.
  • UOM_FK and INSTANCE_FK — Unit-of-measure and instance dimension keys.
  • ACT_RES_USAGE / AVAIL_RES — Actual resource usage and available resource measures.
  • DEPARTMENT, TRX_DATE — Descriptive and date attributes; several columns are hard-coded as 'NA_EDW' or NULL placeholders.

Common Use Cases and Queries

Typical usage involves EDW extraction jobs that read pre-keyed rows for loading the resource utilization fact and locator dimensions. A sample query filtering by locator follows:

SELECT RES_UTIL_PK, LOCATOR_FK, RES_FK, TRX_DATE_FK, ACT_RES_USAGE, AVAIL_RES FROM APPS.OPI_EDW_OPI_RES_UTIL_FCV WHERE LOCATOR_FK LIKE '%PLNT';

Because LOCATOR_FK embeds the instance code, queries can segment by EDW instance. Analysts should note that the unconditional join can yield a Cartesian fan-out when EDW_LOCAL_INSTANCE contains multiple rows; filtering to the intended instance code is advisable before use in downstream joins or aggregations.