Search Results mrp_forecast_items




Overview
Explore in AI Chat

Overview

The MRP_FORECAST_ITEMS table is a core data repository within the Oracle E-Business Suite (EBS) Master Scheduling/MRP module. It serves as the master list of all inventory items that have been explicitly assigned to a specific forecast designator within a given organization. This table establishes the foundational link between forecast definitions and the items they are intended to predict demand for. Its existence is critical for the system's ability to generate a Master Production Schedule (MPS) and Material Requirements Planning (MRP) by defining the scope of items subject to forecast consumption and planning processes. The table's integrity is maintained through foreign key relationships to core inventory and forecast setup tables.

Key Information Stored

The table's structure is defined by a composite primary key that uniquely identifies each forecast-item assignment. The key columns are INVENTORY_ITEM_ID, ORGANIZATION_ID, and FORECAST_DESIGNATOR. This structure enforces that an item can be associated with a specific forecast designator only once per organization. While the provided metadata does not list all attribute columns, the table's primary function is to store this associative relationship. It likely contains additional descriptive or control columns, such as creation dates and last update dates, which are standard in Oracle EBS tables. The essential data point is the presence of a record, which signifies the item's inclusion in the forecast.

Common Use Cases and Queries

This table is central to queries that validate forecast setup, analyze forecast coverage, and troubleshoot planning issues. A common use case is verifying which items are included in a specific forecast before running a planning simulation or analyzing discrepancies. The following sample SQL retrieves all forecasted items for a given designator and organization, joining with the inventory master for item details:

  • SELECT mfi.*, msib.segment1 item_code, msib.description FROM mrp_forecast_items mfi, mtl_system_items_b msib WHERE mfi.inventory_item_id = msib.inventory_item_id AND mfi.organization_id = msib.organization_id AND mfi.forecast_designator = '<DESIGNATOR>' AND mfi.organization_id = <ORG_ID>;

Another critical use case is identifying items that are missing a forecast assignment, which can be achieved via an anti-join between MTL_SYSTEM_ITEMS_B and MRP_FORECAST_ITEMS for planning items within a specific organization and forecast.

Related Objects

The MRP_FORECAST_ITEMS table sits at the nexus of several key planning entities, as evidenced by its foreign key constraints. Its primary relationships are:

  • MTL_SYSTEM_ITEMS_B: Validates that the INVENTORY_ITEM_ID and ORGANIZATION_ID correspond to a valid item definition.
  • MRP_FORECAST_DESIGNATORS: Validates that the FORECAST_DESIGNATOR and ORGANIZATION_ID correspond to a defined forecast.
  • MRP_FORECAST_DATES: Has a bidirectional foreign key relationship. MRP_FORECAST_ITEMS is the parent to the detailed forecast quantities and dates stored in MRP_FORECAST_DATES.
  • MRP_FORECAST_UPDATES: References MRP_FORECAST_ITEMS, logging manual adjustments made to the forecast for specific items.

This network of relationships ensures data consistency across the forecast entry, maintenance, and consumption processes.