Search Results inv.mtl_supply




The INV.MTL_SUPPLY table in Oracle E-Business Suite (EBS) 12.1.1 or 12.2.2 is a critical inventory management table that stores supply-related information for items across the supply chain. It serves as a repository for tracking available, reserved, and in-transit inventory, enabling organizations to manage supply-demand balancing, replenishment, and material planning efficiently. This table is part of the Oracle Inventory (INV) module and integrates with other Oracle EBS modules such as Purchasing, Order Management, and Work in Process.

Key Attributes of INV.MTL_SUPPLY

The MTL_SUPPLY table contains several key columns that define supply details:
  • SUPPLY_TYPE_CODE: Identifies the type of supply (e.g., Purchase Order, Sales Order Return, WIP Job, etc.).
  • INVENTORY_ITEM_ID: References the item in MTL_SYSTEM_ITEMS_B.
  • ORGANIZATION_ID: Specifies the inventory organization.
  • QUANTITY: The available or expected quantity of the supply.
  • PRIMARY_UOM_CODE: Unit of measure for the supply.
  • SUPPLY_SOURCE_ID: Links to the source document (e.g., PO_HEADER_ID for purchase orders).
  • EXPECTED_ARRIVAL_DATE: Estimated delivery date for in-transit supplies.
  • STATUS: Indicates the supply status (e.g., Approved, Received, Cancelled).

Functional Role in Oracle EBS

The MTL_SUPPLY table supports core inventory processes:
  1. Supply-Demand Matching: Used by Oracle Inventory and Advanced Supply Chain Planning (ASCP) to match available supply with demand (e.g., sales orders, work orders).
  2. Replenishment Planning: Provides data for min-max planning, reorder point calculations, and automated replenishment workflows.
  3. ATP (Available-to-Promise): Enables real-time ATP checks by aggregating supply data for order promising.
  4. Inter-Organization Transfers: Tracks in-transit shipments between warehouses.

Integration with Other Modules

The table integrates with:
  • Purchasing (PO): Captures PO-related supplies via SUPPLY_TYPE_CODE = 'PO'.
  • Order Management (OM): Tracks returns (SUPPLY_TYPE_CODE = 'RETURN').
  • Work in Process (WIP): Manages job completions (SUPPLY_TYPE_CODE = 'WIP').
  • MRP/ASCP: Feeds supply data for material requirements planning.

Technical Considerations

  • Indexes: Key indexes include MTL_SUPPLY_N1 (ORGANIZATION_ID, INVENTORY_ITEM_ID) and MTL_SUPPLY_N2 (SUPPLY_SOURCE_ID, SUPPLY_TYPE_CODE).
  • Partitioning: In high-volume environments, partitioning by ORGANIZATION_ID improves query performance.
  • Purge Logic: Supplies are purged via concurrent programs like "Purge Obsolete Inventory Data."

Common Use Cases

  1. Supply Visibility Reports: Custom queries to analyze on-hand vs. in-transit supplies.
  2. Backorder Resolution: Identifying alternate supplies to fulfill delayed orders.
  3. Audit Trails: Tracking historical supply changes for compliance.

Conclusion

The INV.MTL_SUPPLY table is a foundational component of Oracle EBS Inventory, enabling end-to-end supply chain visibility. Its design supports complex inventory optimization scenarios while maintaining tight integration with procurement, manufacturing, and order fulfillment processes. Proper understanding of this table is essential for customizations, reporting, and performance tuning in Oracle EBS implementations.