Search Results line_sequence_id




Overview
Explore in AI Chat

Overview

The OSM.AS_MRP_INTERFACE_LINES table is a core data interface table within the Oracle E-Business Suite (EBS) Application Scheduler (AS) module. Its primary function is to serve as a staging area for detailed forecast line data that is loaded from external systems for subsequent Material Requirements Planning (MRP) processing. This table holds individual forecast entries, which are then processed by Oracle's MRP engine to generate supply chain plans. Operating within the OSM schema, it is integral to the inbound data integration flow for demand planning in releases 12.1.1 and 12.2.2.

Key Information Stored

The table stores transactional line items for forecast interfaces. The LINE_SEQUENCE_ID column is the mandatory primary key, uniquely identifying each forecast line record. Key transactional columns include SEQUENCE_ID, which links the line to its parent header record in the AS_MRP_INTERFACE table; ITEM_ID and FORECAST_DATE to specify the item and date of the forecast; and QUANTITY for the forecasted amount. The PROCESS_STATUS and ERROR_MESSAGE columns are critical for tracking the success or failure of the interface processing for each line. Additional context is provided by columns such as INTEREST_TYPE_ID, PRIMARY_INTEREST_CODE_ID, and CONFIDENCE_PERCENTAGE, which qualify the forecast data.

Common Use Cases and Queries

The primary use case is the validation and troubleshooting of forecast data loads. Administrators commonly query this table to identify lines that failed to process or to analyze forecast data before submission to MRP. A typical query involves checking the process status:

  • Identifying pending or error records: SELECT LINE_SEQUENCE_ID, ITEM_ID, FORECAST_DATE, QUANTITY, PROCESS_STATUS, ERROR_MESSAGE FROM OSM.AS_MRP_INTERFACE_LINES WHERE PROCESS_STATUS != 2 AND SEQUENCE_ID = <interface_id>;
  • Aggregating forecast quantities by item: SELECT ITEM_ID, SUM(QUANTITY) FROM OSM.AS_MRP_INTERFACE_LINES WHERE FORECAST_DATE BETWEEN :p_start_date AND :p_end_date GROUP BY ITEM_ID;
  • Extracting a full interface set for a given transaction: SELECT * FROM OSM.AS_MRP_INTERFACE_LINES WHERE SEQUENCE_ID = <parent_id> ORDER BY LINE_SEQUENCE_ID;

Related Objects

The table has defined relationships with other EBS objects, primarily through foreign key constraints. The central relationship is with its parent header table:

  • AS_MRP_INTERFACE: The SEQUENCE_ID column in AS_MRP_INTERFACE_LINES is a foreign key referencing the AS_MRP_INTERFACE table. This links each forecast detail line to its corresponding interface control record.
  • Primary Key Constraint: The table's primary key is enforced by the index AS_MRP_INTERFACE_LINES_U1 on the LINE_SEQUENCE_ID column.

As per the provided metadata, there are no other documented foreign keys where this table references other objects, nor are there views or synonyms explicitly listed as dependencies. Its role is predominantly as a child to the AS_MRP_INTERFACE header.