Search Results consumption_level

Overview

EDW_MRP_FCDM_SET_LCV is a collection view owned by the APPS schema in Oracle E-Business Suite. It is delivered as part of the ISC - Supply Chain Intelligence product family and is classified as VALID. The view materializes the Forecast Set level of the Forecast dimension within the Oracle Supply Chain Intelligence / Enterprise Data Warehouse (EDW) reporting model.

Its purpose is to expose a single, denormalized row per forecast set (forecast designator) for consumption by EDW collection programs and downstream analytical reporting. The view consolidates data drawn from forecast designator definitions, organization parameters, instance registration, and lookup code translations, then presents a stable set of columns — including surrogate keys, instance codes, and descriptive attributes — that the EDW staging and dimension build process can reference. Because it is a collection view rather than a transactional entity, it is not used to post or modify data; it exists to standardize how forecast set metadata is read during extract.

Underlying Base Objects

The view text joins four underlying objects:

• MRP_FORECAST_DESIGNATORS (FD) — the primary driver, supplying forecast set names, descriptions, organization identifiers, creation and disable dates, update type, and last update timestamps. The view explicitly filters FD.FORECAST_SET IS NULL, meaning it captures designators that represent a forecast set rather than lower-level forecast entries.
• MTL_PARAMETERS (MP) — joined on ORGANIZATION_ID to retrieve the ORGANIZATION_CODE for the owning inventory organization.
• MFG_LOOKUPS (ML) — joined on UPDATE_TYPE with LOOKUP_TYPE = 'MRP_UPDATE_TYPE' to translate the update type code into its display MEANING.
• EDW_LOCAL_INSTANCE (INST) — provides the INSTANCE_CODE that identifies the source EBS instance in the warehouse.

The view thereby behaves as a dimension-level collector over these base objects, shaping designator-level rows into EDW-friendly output.

Key Columns

• FORECAST_SET_PK — surrogate primary key for the forecast set at the EDW dimension level.
• FORECAST_SET_NAME — the business name of the forecast set, typically composed from forecast designator and organization context.
• FORECAST_SET_DP — the display/descriptive representation of the forecast set, produced by concatenating the forecast designator with the organization code, for example Designator(ORG_CODE).
• CONSUMPTION_LEVEL — the consumption-level attribute of the forecast set.
• DESCRIPTION, CREATION_DATE, DISABLE_DATE, LAST_UPDATE_DATE — descriptive and audit-oriented attributes carried from the designator record.
• INSTANCE_CODE — the source EBS instance identifier.
• NAME — the translated lookup meaning for the update type.
• USER_ATTRIBUTE1 through USER_ATTRIBUTE5 — descriptive flexfield columns reserved for customer-specific extensions.

Common Use Cases and Queries

A frequent need is to identify all forecast sets available for reporting in a given instance. The following query returns the key attributes:

• SELECT forecast_set_name, name, description FROM edw_mrp_fcdm_set_lcv ORDER BY forecast_set_name;

To filter for forecast sets that are still active (not disabled), the disable date can be tested:

• SELECT forecast_set_pk, forecast_set_name, disable_date FROM edw_mrp_fcdm_set_lcv WHERE disable_date IS NULL;

For warehouse integration checks, the instance code and update type translation are often surfaced together:

• SELECT instance_code, forecast_set_name, name FROM edw_mrp_fcdm_set_lcv WHERE name = 'Manual';

Finally, because the view includes user attribute columns, extensions can be queried directly:

• SELECT forecast_set_name, user_attribute1 FROM edw_mrp_fcdm_set_lcv WHERE user_attribute1 IS NOT NULL;

These patterns support forecast dimension population, reconciliation of forecast sets across instances, and validation of collected data prior to loading the Supply Chain Intelligence warehouse.