Results for “msd_mfg_fcst_cs_v”

24 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

MSD_MFG_FCST_CS_V is an APPS-owned database view in the Oracle E-Business Suite Demand Planning module (product code MSD). It exposes the Manufacturing Forecast in a flattened, analytic-ready form suitable for reporting, integration, and downstream consumption by planning engines and data warehouses. The view is documented as VALID in both ETRM 12.1.1 and 12.2.2 metadata.

Functionally, the view presents manufacturing forecast rows joined to their corresponding level member identifiers. Unlike many forecast extraction views, MSD_MFG_FCST_CS_V is explicitly not stripped by the demand plan id. Instead, it carries a FORECAST_DESIGNATOR column that can be combined with the demand plan parameter name to filter records by demand plan when required. This design supports scenarios where a single physical forecast table must serve multiple planning contexts while preserving the ability to segregate data at query time.

The view is relevant to the search term chn_level_value_pk, which appears as one of its columns. CHN_LEVEL_VALUE_PK represents the surrogate key of the sales channel level member associated with each forecast row, enabling reporting by channel dimension.

Underlying Base Objects

According to documented ETRM metadata, the view is defined over two base objects, both referenced through synonyms in the APPS schema:

The joins are performed on INSTANCE and SR_LEVEL_PK, constrained by LEVEL_ID to enforce dimension roles: LEVEL_ID = 7 for inventory organization, LEVEL_ID = 1 for product/item, LEVEL_ID = 27 for sales channel, and LEVEL_ID = 11 for ship-to location. The sales channel and ship-to location joins are outer joins, allowing forecast rows that lack those dimensions to remain in the result set.

Key Columns

Common Use Cases and Queries

Typical scenarios include channel-level forecast reporting, feed extraction into custom planning marts, and reconciliation of manufacturing forecasts against demand plans.

Forecast by sales channel:

  • SELECT FORECAST_DESIGNATOR, CHN_LEVEL_VALUE_PK, FORECAST_DATE, CURRENT_QUANTITY FROM APPS.MSD_MFG_FCST_CS_V WHERE CHN_LEVEL_VALUE_PK IS NOT NULL;

Channel forecast for a specific item and organization:

  • SELECT CHN_LEVEL_VALUE_PK, SUM(CURRENT_QUANTITY) QTY FROM APPS.MSD_MFG_FCST_CS_V WHERE PRD_LEVEL_VALUE_PK = :item_pk AND ORG_LEVEL_VALUE_PK = :org_pk GROUP BY CHN_LEVEL_VALUE_PK;

When isolating by demand plan, join or filter on FORECAST_DESIGNATOR together with the relevant demand plan parameter, since the view itself is not pre-stripped by demand plan id.