Search Results mrp_available_to_promise




Overview
Explore in AI Chat

Overview

The MRP_AVAILABLE_TO_PROMISE table is a core data repository within Oracle E-Business Suite's Master Scheduling/MRP module. It serves as the system of record for Available-to-Promise (ATP) calculations for master scheduled items. ATP is a critical business function that determines the uncommitted portion of inventory and planned supply that is available to fulfill new customer orders or demand. This table stores the results of ATP inquiries and simulations, enabling organizations to provide accurate delivery promises based on real-time supply and demand balances. Its role is integral to the order promising and fulfillment processes, directly impacting customer service levels and inventory management efficiency.

Key Information Stored

The table's structure is designed to capture the ATP snapshot for a specific item, organization, and master schedule at a point in time. The primary and unique keys define its granularity. The TRANSACTION_ID serves as the primary key for each ATP record. The unique key, comprised of INVENTORY_ITEM_ID, ORGANIZATION_ID, COMPILE_DESIGNATOR, and SCHEDULE_DATE, ensures that only one ATP record exists for a given item, in a specific organization, under a particular master schedule (compile designator), on a specific date. Key data columns include the SCHEDULE_DATE, which is the future date for which the ATP quantity is calculated, and other supporting columns that would typically hold the cumulative ATP quantity, supply and demand details, and sourcing information, though the specific column list is not detailed in the provided metadata.

Common Use Cases and Queries

The primary use case is querying ATP information for order management and planning. A common pattern is to check the available quantity for a specific item on a requested ship date to confirm an order promise. Analysts may also run trend reports to analyze how ATP profiles change over time. Sample SQL often involves filtering on the unique key columns and joining to item master tables for descriptions.

  • ATP Check for Order Entry: A query to retrieve the ATP quantity for an item (ID 1000) in organization 101, using the 'MAIN' schedule, for a schedule date of a requested shipment.
  • ATP Profile Report: A summary report joining to MRP_SYSTEM_ITEMS to list ATP quantities for a range of critical items over the next 30 days, grouped by item and date.

Related Objects

The MRP_AVAILABLE_TO_PROMISE table has defined relationships with other critical MRP tables, primarily through foreign key constraints. The documented foreign key relationship is with the MRP_SYSTEM_ITEMS table. This ensures referential integrity, guaranteeing that every ATP record corresponds to a valid master scheduled item defined in the system. The join is performed on three key columns that together form the item's identity within the MRP module:

  • MRP_SYSTEM_ITEMS: Joined via INVENTORY_ITEM_ID, ORGANIZATION_ID, and COMPILE_DESIGNATOR. This provides access to item attributes, planning parameters, and descriptive information relevant to the master schedule.

While not listed in the provided metadata, this table is also conceptually central to the ATP inquiry forms and is populated by the underlying ATP engine processes within the Oracle MRP application.