Results for “edw_mrp_forecast_m”

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

Overview

EDW_MRP_FORECAST_M is a denormalized forecast master table that resides in the ISC schema and is documented under the BIS – Applications BIS product family within Oracle E-Business Suite 12.1.1 and 12.2.2. It appears in the Enterprise Technical Reference Model (ETRM) as a physical, warehouse-facing structure rather than a native transactional MRP object. The "_M" suffix and the EDW_ prefix indicate that it is intended as a master-level staging or reporting table consumed by the Enterprise Data Warehouse layer, exposing both forecast header data (FCST_*) and forecast set data (FSTS_*) side by side in a single wide row.

The ETRM documentation marks this object as "Not implemented in this database," meaning the table is registered in the ETRM metadata but is not physically deployed in every environment. Its Data Vault classification, mined heuristically from the foreign-key structure, is standalone. In Data Vault modeling terms, this suggests the table behaves as an independent structure with no parent hubs or links asserted by constraint, and it should be modeled as a hub or standalone satellite candidate rather than as a dependent link. Because it carries a two-part business key, a satellite treatment keyed on the forecast identifier is the most natural fit.

Key Information Stored

The documented physical schema contains 29 columns. The most operationally significant are the key, descriptive, and lifecycle fields rather than the full enumeration.

• FCST_FORECAST_PK – Surrogate primary key for the forecast record; combined with FCST_FORECAST_PK_KEY in unique index EDW_MRP_FORECAST_M_U1.
• FCST_FORECAST_PK_KEY – The cloned/normalized source key; carries its own unique index EDW_MRP_FORECAST_M_U2 and forms the documented primary key EDW_MRP_FCDM_FORECAST_UK.
• FSTS_FORECAST_SET_PK / FSTS_FORECAST_SET_PK_KEY – Surrogate and source keys for the parent forecast set, linking a forecast to its containing set.
• FCST_FORECAST_NAME, FCST_NAME, FCST_DESCRIPTION – Forecast identification and descriptive text.
• FCST_DISABLE_DATE and FSTS_DISABLE_DATE – Lifecycle end-dating, essential for point-in-time reporting.
• FCST_INSTANCE_CODE, FSTS_INSTANCE_CODE – Source-instance discriminators for multi-org or multi-instance consolidation.
• FSTS_CONSUMPTION_LEVEL – Forecast set consumption behavior, relevant to MRP planning logic.
• FSTS_FORECAST_SET_NAME, FSTS_NAME, FSTS_DESCRIPTION, FSTS_FORECAST_SET_DP – Forecast set context.
• FCST_USER_ATTRIBUTE1–5 and FSTS_USER_ATTRIBUTE1–5 – Extensible user-defined descriptive flexfield-style attributes.
• CREATION_DATE and LAST_UPDATE_DATE – Audit stamps used for incremental extraction and change detection.

Business-key candidates are the unique indexes EDW_MRP_FORECAST_M_U1 (FCST_FORECAST_PK, FCST_FORECAST_PK_KEY) and EDW_MRP_FORECAST_M_U2 (FCST_FORECAST_PK_KEY). The surrogate PK (EDW_MRP_FCDM_FORECAST_UK) is distinct from these derived natural keys.

Common Use Cases and Queries

Typical usage centers on warehouse extraction and forecast-versus-actual analysis. A staging query joins forecast to set context:

• Current, non-disabled forecasts: SELECT fcst_forecast_name, fsts_forecast_set_name FROM edw_mrp_forecast_m WHERE fcst_disable_date IS NULL;
• Incremental loads: WHERE last_update_date > :last_run.
• Set-level rollups: GROUP BY fsts_forecast_set_pk_key.
• Consumption-level reporting using FSTS_CONSUMPTION_LEVEL to separate dependent versus independent demand.
• Reconciliation of source instance codes across consolidated organizations.

Related Objects

Because the heuristic classification is standalone, no FK constraints were mined. The significant dependents are logical rather than enforced.

• MRP_FORECAST_DATES / MRP_FORECAST_ITEMS – native MRP forecast detail tables joined via the forecast PK.
• MRP_FORECAST_SETS – seeded source for FSTS_FORECAST_SET_PK_KEY.
• MRP_FORECAST_DESIGNATORS – associates forecasts with items and organizations.
• MTL_SYSTEM_ITEMS_B – item validation for forecast designators.
• EDW_MRP_FORECAST_D / _F – companion dimension and fact structures in the EDW star schema.