Search Results mr_actn_tbl




Overview
Explore in AI Chat

Overview

The MR_ACTN_TBL is a core data table within the Oracle E-Business Suite (EBS) Process Manufacturing Process Planning (GMP) module. Its primary function is to store Material Requirements Planning (MRP) action messages generated by the MRP planning engine. These messages represent recommended actions—such as rescheduling, canceling, or creating new planned orders—to address material supply and demand imbalances for process-manufactured items. The table acts as a critical output repository from the MRP run, providing the actionable data that planners use to maintain optimal production schedules and inventory levels within a process manufacturing environment.

Key Information Stored

The table's structure is designed to uniquely identify and describe each recommended action. Its composite primary keys, MR_ACTN_TBLI1 and MR_ACTN_TBL_PK, highlight the essential identifiers: the MRP run identifier (MRP_ID), the specific action number (ACTION_NO), and the associated item (ITEM_ID), warehouse (WHSE_CODE), and event date (EVENT_DATE). Key columns include FORMULA_ID, linking the action to a specific process formula; ORGN_CODE, identifying the organization; and WHSE_CODE_2, which may indicate a secondary or transfer warehouse. The table also holds the DOC_TYPE, which can reference document types in SY_DOCS_MST, potentially linking actions to supporting documentation or change orders.

Common Use Cases and Queries

The primary use case is reviewing and implementing MRP action messages within the Process Manufacturing Planner's Workbench or related planning interfaces. Planners query this table to filter actions by item, warehouse, date, or action type (implied by the message content). A typical reporting query would join MR_ACTN_TBL to item (IC_ITEM_MST) and warehouse (IC_WHSE_MST) master tables to present actionable data. For example: SELECT a.ACTION_NO, i.ITEM_NO, a.EVENT_DATE, a.WHSE_CODE FROM GMP.MR_ACTN_TBL a, IC_ITEM_MST i WHERE a.ITEM_ID = i.ITEM_ID AND a.MRP_ID = :p_mrp_run_id ORDER BY a.EVENT_DATE; Another critical use case involves the pegging relationships, where the foreign key from MR_PEGG_TBL links supply and demand elements to the specific action messages that address them, enabling traceability.

Related Objects

MR_ACTN_TBL is centrally connected to numerous master and transactional tables via foreign key constraints. Key related objects include:

  • IC_ITEM_MST / IC_ITEM_MST_B: For item master data.
  • IC_WHSE_MST: For warehouse master data (both primary and secondary warehouses).
  • FM_FORM_MST: For the process formula associated with the action.
  • MR_PARM_DTL: For details of the MRP run parameters that generated the actions.
  • SY_ORGN_MST: For organization master data.
  • MR_PEGG_TBL: A dependent table that references MR_ACTN_TBL, establishing pegging relationships between supply, demand, and action messages.
This network of relationships underscores the table's integral role in the Process Planning data model.