Results for “mrp_forecast_items”

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

Overview

MRP_FORECAST_ITEMS is a Master Scheduling/MRP (MRP) schema table that records the items participating in a forecast. In Oracle EBS 12.1.1 and 12.2.2, forecast data is organized hierarchically: a forecast designator defines the forecast set, and individual end items or components are associated with that designator so that Planning can consume forecast demand during the MRP/MPS planning run. MRP_FORECAST_ITEMS serves as the item-level roster for each forecast, tying an inventory item in a specific organization to a forecast designator, and optionally to an alternate BOM designator and a forecast MAD (Mean Absolute Deviation) value.

From a Data Vault modeling perspective, the mined FK structure classifies this table as hub-leaning. Its composite primary key is composed entirely of business keys (item, organization, and designator), which is characteristic of a hub or a hub-adjacent structure rather than a pure satellite. Analysts building a dimensional or Data Vault representation should treat MRP_FORECAST_ITEMS as the item-forecast association hub, with the descriptive and audit columns behaving as satellite attributes.

Key Information Stored

The table contains 30 documented columns. The primary key MRP_FORECAST_ITEMS_PK is a composite of INVENTORY_ITEM_ID, ORGANIZATION_ID, and FORECAST_DESIGNATOR. A second unique index, MRP_FORECAST_ITEMS_U1, enforces the same triplet in the order ORGANIZATION_ID, FORECAST_DESIGNATOR, INVENTORY_ITEM_ID. Because the PK columns are themselves the business identifiers, there is no separate surrogate key; the composite key functions as both surrogate and business key for uniqueness purposes.

• INVENTORY_ITEM_ID — the item master identifier for the forecasted item (FK to MTL_SYSTEM_ITEMS_B).
• ORGANIZATION_ID — the inventory organization context for the item.
• FORECAST_DESIGNATOR — the forecast set/designator the item belongs to (FK to MRP_FORECAST_DESIGNATORS).
• ALTERNATE_BOM_DESIGNATOR — optional alternate BOM used when exploding or planning the item.
• FORECAST_MAD — the Mean Absolute Deviation value supporting forecast accuracy tracking.
• REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE — concurrent program and request context that last touched the row.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — standard audit columns.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — descriptive flexfield storage for customer-defined forecast item attributes.

Common Use Cases and Queries

Typical uses include validating which items are in a forecast before a planning run, extracting forecast item lists for reporting, and reconciling forecast quantities in MRP_FORECAST_DATES against their defining items. A representative query joins the item and designator dimensions:

• List items in a forecast: SELECT fi.inventory_item_id, fi.organization_id, fi.forecast_designator FROM mrp.mrp_forecast_items fi WHERE fi.forecast_designator = :designator AND fi.organization_id = :org;
• Describe items: join to MTL_SYSTEM_ITEMS_B on INVENTORY_ITEM_ID and ORGANIZATION_ID to retrieve concatenated segment descriptions.
• Forecast quantities by item: join MRP_FORECAST_DATES on INVENTORY_ITEM_ID, ORGANIZATION_ID, and FORECAST_DESIGNATOR to sum forecast demand.
• Alternate BOM impact: filter on ALTERNATE_BOM_DESIGNATOR to isolate items planned with alternate structures.
• Accuracy reporting: report FORECAST_MAD alongside forecast versus actual consumption.

Related Objects

The FK metadata identifies the principal related objects and their join columns:

• MTL_SYSTEM_ITEMS_B — joined on INVENTORY_ITEM_ID and ORGANIZATION_ID; supplies item master attributes.
• MRP_FORECAST_DESIGNATORS — joined on FORECAST_DESIGNATOR and ORGANIZATION_ID; defines the forecast set.
• MRP_FORECAST_DATES — references this table via END_ITEM_ID and via INVENTORY_ITEM_ID, ORGANIZATION_ID, FORECAST_DESIGNATOR; holds dated forecast quantities.
• MRP_FORECAST_UPDATES — references this table via INVENTORY_ITEM_ID, ORGANIZATION_ID, FORECAST_DESIGNATOR; tracks forecast change activity.
• MRP_FORECAST_ITEMS_PK / MRP_FORECAST_ITEMS_U1 — the unique indexes governing row uniqueness.