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:
- MSD_MFG_FORECAST — the fact-like table holding forecast quantities, dates, bucket types, designators, and level foreign keys. In the view text it is aliased as MBD.
- MSD_LEVEL_VALUES — the level member dimension table, joined multiple times (aliases ORG_PK, ITEM_PK, SALES_CHANNEL_PK, SHIP_TO_LOC_PK) to translate surrogate level keys into LEVEL_PK values.
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
- FORECAST_DESIGNATOR — identifies the forecast source; combined with demand plan parameters to isolate a specific plan.
- PRD_LEVEL_ID / PRD_LEVEL_VALUE_PK — product level id (1) and item surrogate key.
- GEO_LEVEL_ID / GEO_LEVEL_VALUE_PK — geography (ship-to location) level id (11) and key.
- ORG_LEVEL_ID / ORG_LEVEL_VALUE_PK — organization level id (7) and inventory organization key.
- CHN_LEVEL_ID / CHN_LEVEL_VALUE_PK — sales channel level id (27) and channel surrogate key, sourced from the outer-joined SALES_CHANNEL_PK alias.
- UD1/UD2_LEVEL_ID and VALUE_PK — user-defined dimension placeholders, returned as NULL by this view.
- TIME_LEVEL_ID, FORECAST_DATE — time bucket type and forecast date.
- ORIGINAL_QUANTITY, CURRENT_QUANTITY — forecast quantities before and after adjustments.
- Audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, LAST_REFRESH_NUM, CREATED_BY_REFRESH_NUM, ACTION_CODE.
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.
-
View: MSD_MFG_FCST_CS_V 12.2.2
This view specifies the Manufacturing Forecast. This is not stripped by the demand plan id. It has a forecast designator that could be used along with the demand plan parameter's nameto strip this information by the demand plan. MRP_FORECA
APPS.MSD_MFG_FCST_CS_V·↳ MSD_LEVEL_VALUES·↳ MSD_MFG_FORECAST·Explore MSD module →
-
View: MSD_MFG_FCST_CS_V 12.1.1
This view specifies the Manufacturing Forecast. This is not stripped by the demand plan id. It has a forecast designator that could be used along with the demand plan parameter's nameto strip this information by the demand plan. MRP_FORECA
APPS.MSD_MFG_FCST_CS_V·↳ MSD_LEVEL_VALUES·↳ MSD_MFG_FORECAST·Explore MSD module →
-
VIEW: APPS.MSD_MFG_FCST_CS_V 12.1.1
-
VIEW: APPS.MSD_MFG_FCST_CS_V 12.2.2
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
eTRM - MSD Tables and Views 12.1.1
This is the fact table that stores the UOM conversions information.
-
eTRM - MSD Tables and Views 12.2.2
This is the fact table that stores the UOM conversions information.
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
eTRM - MSD Tables and Views 12.1.1
This is the fact table that stores the UOM conversions information.
-
eTRM - MSD Tables and Views 12.2.2
This is the fact table that stores the UOM conversions information.