Search Results in_process




Overview
Explore in AI Chat

Overview

The APPS.MRP_UPDATE_MRP_INFO_PK package body is a supply chain planning utility within Oracle E-Business Suite (available in both 12.1.1 and 12.2.2). Its purpose is to reconcile and update planning-related information after relief or transaction activity has occurred against work orders, purchase orders, requisitions, receipts, shipments, and flow schedules. The package acts as a post-processing mechanism that refreshes the material requirements planning (MRP/MPS) records so that supply, demand, and schedule dates remain synchronized with actual execution activity.

The package is classified as an OTHER API in ETRM, meaning it is not a formally published open interface but is instead an internal concurrent-processing routine. It is tightly coupled to the MRP relief interface and is designed to be driven by a batch or concurrent manager invocation that supplies organization, item, user, and request identifiers.

Key Procedures and Functions

The package exposes a single documented procedure:

  • MRP_UPDATE_MRP_COLS — The core worker routine. It takes organization, item, user, and request identifiers and processes qualifying rows from the relief interface. It uses constants to distinguish relief types and record categories, including work order (1), purchase order (2), purchase requisition (5), PO receipt (6), shipment (7), shipment receipt (8), and flow schedule (9). The constant IN_PROCESS (3) is the process status filter that scopes the update to rows currently being processed, while ALREADY_PROCESSED (5) marks completed rows. The procedure also declares exception handlers for the Oracle busy (-54) and deadlock (-60) errors, reflecting the concurrency-sensitive nature of the operation.

Tables Accessed

The package reads and writes across the primary planning and execution tables (via APPS synonyms):

  • MRP_RELIEF_INTERFACE — The driving interface table. The cursor selects rows where process_status = IN_PROCESS, filtering by request ID, and optionally by inventory item and organization.
  • MRP_RECOMMENDATIONS — Stores planning recommendations that are refreshed as supply/demand changes are recognized.
  • MRP_SCHEDULE_DATES and MRP_SCHEDULE_DESIGNATORS — Maintain schedule date and designator information for planned and scheduled supplies.
  • MTL_SUPPLY — Holds supply records (scheduled receipts, on-hand supply) that are updated to reflect actual execution.
  • MTL_UNITS_OF_MEASURE — Provides unit-of-measure conversion context for quantity updates.
  • WIP_DISCRETE_JOBS and WIP_REQUIREMENT_OPERATIONS — The cursor joins these to identify discrete jobs and their requirement operations associated with work order relief.
  • WIP_FLOW_SCHEDULES — Supports flow schedule relief processing for repetitive manufacturing.
  • DBMS_LOCK — Used to serialize access and prevent concurrent processing conflicts.

Usage Notes

This package is not intended for direct invocation by end users or by arbitrary custom code. It is typically invoked by the planning manager through concurrent programs or internal relief processing logic that populates MRP_RELIEF_INTERFACE with rows in IN_PROCESS status. Because the procedure relies on request ID and process status to scope its work, it must be called within the context of a valid concurrent request.

Integrators should treat this as an internal API. Any customization should avoid modifying its cursor logic or process status constants, as changes can disrupt the relief reconciliation cycle. The presence of deadlock and busy exception handlers indicates it may be scheduled alongside other planning jobs, and retry logic is expected. The single revision noted in the header (120.1, 2006) suggests the package has remained stable across the 12.x releases.