Search Results as_mrp_interface




Overview
Explore in AI Chat

Overview

The AS_MRP_INTERFACE table is a core data object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the AS (Sales Foundation) product module. Owned by the OSM schema, its primary function is to serve as the staging and header information repository for the interface between Oracle Sales Management (OSM) and Manufacturing Resource Planning (MRP). This table acts as the parent record in the data flow, holding the essential identifiers and control information for batches of demand data that are transferred from the sales order management system to the supply chain planning engine. Its existence is critical for ensuring a structured and auditable integration between sales forecasting/orders and production planning processes.

Key Information Stored

While the provided ETRM metadata does not list individual columns, the documented structure reveals the essential data architecture. The table's primary key is the SEQUENCE_ID column, which uniquely identifies each interface transaction or batch header. This SEQUENCE_ID is the critical link to associated detail records. Typically, interface tables in this context also store control columns such as PROCESS_STATUS to indicate if the record is pending, processed, or in error, REQUEST_ID for concurrent process tracking, and CREATION_DATE. The header-level nature of the table suggests it may also hold summary information about the interfaced demand data, such as a schedule designator or planning parameters, which apply to all related detail lines.

Common Use Cases and Queries

The primary use case revolves around the integration and troubleshooting of the OSM-to-MRP demand interface. Common operational activities include monitoring the status of interfaced data batches and identifying records that have failed to process into MRP. A typical query would join the header table with its detail lines to get a complete view of a specific interface batch.

  • Monitoring Interface Status: SELECT sequence_id, process_status, creation_date FROM osm.as_mrp_interface WHERE process_status = 'PENDING';
  • Investigating a Specific Batch: SELECT hdr.*, ln.* FROM osm.as_mrp_interface hdr JOIN osm.as_mrp_interface_lines ln ON hdr.sequence_id = ln.sequence_id WHERE hdr.sequence_id = <ID>;

Data in this table is typically populated by OSM programs or custom extensions and is consumed by standard MRP planning interface concurrent programs which read, validate, and transfer the data into core MRP tables.

Related Objects

The AS_MRP_INTERFACE table has a direct, documented parent-child relationship with one other key object in the interface flow, as per the provided foreign key metadata.

  • AS_MRP_INTERFACE_LINES: This is the primary dependent table. It holds the detailed demand schedule lines (e.g., item, quantity, date) for each header batch. The tables are joined via the SEQUENCE_ID column, where AS_MRP_INTERFACE_LINES.SEQUENCE_ID is a foreign key referencing AS_MRP_INTERFACE.SEQUENCE_ID. This relationship is fundamental, as the header record in AS_MRP_INTERFACE must exist before any detail lines can be inserted against it.

While not listed in the provided excerpt, this interface structure ultimately feeds into core Oracle Manufacturing tables such as MRP_SCHEDULE_DATES and MRP_SCHEDULE_ITEMS via standard EBS interface programs.