Understanding Master Production Planning, MRP, and Oracle ERP Core Modules

Master Production Planning (MPS)

MPS is a high‑level planning process that determines the coarse demand for finished or configurable semi‑finished products over multiple time buckets, linking sales forecasts with detailed material requirements planning (MRP) and ensuring a stable, balanced production schedule before detailed short‑term planning.

From MPS to Material Requirements Planning (MRP)

MRP translates the MPS output into detailed procurement and production orders by exploding the bill of materials (BOM), considering lead times, inventory on hand, safety stock, and resource constraints; it typically runs weekly with incremental daily runs to keep material and capacity plans up to date.

Oracle ERP Supplier Management

Supplier data is stored in a three‑layer structure—supplier header (PO_VENDORS), supplier sites (PO_VENROD_SITES), and contacts (PO_VENDOR_CONTACTS)—allowing multiple sites per supplier, each with specific purchasing, payment, and shipping attributes, as well as linked payment terms, tax codes, and FOB information.

Oracle ERP Material Management

The core material table inv.mtl_system_items holds item definitions, including organization‑specific records, item type, unit of issue, status, and various flags; items are assigned to category sets, have configurable lead‑time calculations, and can be managed through organization‑level allocation, BOM enablement, and cost‑enabled settings.

Oracle ERP Procurement Management

Procurement processes encompass requisition, purchase order, and receipt, with core tables such as po.po_requisition_headers_all , po.po_headers_all , and rcv_shipment_headers ; the system supports standard purchase orders, planned orders, blanket agreements, and contract agreements, along with controls for deletion, cancellation, freezing, and matching of three‑way documents (order, receipt, invoice).

Oracle ERP Inventory Management

Inventory is organized by inventory organizations, sub‑inventories, and optional locators; transactions (receipts, issues, transfers, adjustments) are recorded in inv.mtl_material_transactions and affect on‑hand quantities, with support for lot, serial, and version control, as well as periodic and cycle counting based on ABC classification.

Oracle ERP Financial Management

The General Ledger defines accounting periods, chart of accounts, and base currency; journal entries flow from operational modules (e.g., Payables, Receivables) into GL via interface tables, supporting balanced debit‑credit posting, voucher types, and the generation of financial statements such as balance sheets and income statements.