Search Results wip_flow_schedules_proc




Overview
Explore in AI Chat

Overview

APPS.WIP_MRP_RELIEF is a PL/SQL package in Oracle E-Business Suite that supports the integration between Work in Process (WIP) and Material Requirements Planning (MRP). Its central purpose is to record and propagate relief transactions that inform the planning engine when supply commitments change — for example when a discrete job's quantity, scheduled completion date, demand class, or bill of material designation is modified. The package captures both the new and old values of affected attributes and posts the delta to the MRP relief interface, allowing the planner to recalculate net requirements without a full regeneration of the plan.

The package body declares AUTHID CURRENT_USER, meaning that its SQL statements execute under the privileges of the invoking user rather than the definer. It is classified as an OTHER API, indicating it is not a public, supported business API but an internal utility invoked by WIP processing logic. Two overloaded entry points are exposed, one for discrete jobs and one for flow schedules, reflecting the two primary WIP work order models.

Key Procedures and Functions

  • WIP_DISCRETE_JOBS_PROC — Handles MRP relief for standard discrete jobs. It receives the item and organization identifiers along with paired new/old values for the attributes that affect planning: MPS quantity, scheduled completion date, bill designator, bill revision date, demand class, status type, quantity completed, date completed, project, and task. The pairing of old and new values allows the relief logic to compute the change to feed downstream planning.
  • WIP_FLOW_SCHEDULES_PROC — The flow schedule counterpart. It follows the same new/old delta pattern but adds parameters specific to repetitive/flow manufacturing, including new and old request identifiers and a demand source type and demand source line. These identify the originating demand reference that a flow schedule satisfies, which discrete jobs do not carry in the same form.

Both procedures return no value and are purely side-effecting: they write relief records rather than returning data to the caller. No parameter lists beyond those documented are assumed here.

Tables Accessed

  • MRP_RELIEF_INTERFACE — the principal staging table into which relief transactions are inserted for subsequent consumption by the planning processes.
  • MRP_RELIEF_INTERFACE_S — the sequence table used to generate unique identifiers for the interface rows.
  • MTL_SYSTEM_ITEMS — read to validate and resolve item attributes such as planning status and replenishment information.
  • WIP_REQUIREMENT_OPERATIONS — referenced in support of the work order requirement and operation data that drives the relief calculation.

Usage Notes

WIP_MRP_RELIEF is not intended for direct invocation by end users. It is called by WIP maintenance logic whenever a discrete job or flow schedule is created or changed in a way that affects material supply — quantity updates, date rescheduling, status transitions, completion entries, and project or task reassignments. The documented metadata indicates it is referenced by six other packages, confirming its role as a shared internal utility invoked from multiple WIP entry points rather than from forms or concurrent programs directly.

Because it is an internal package with no supported public interface, customizations should avoid calling it directly. A more appropriate integration approach is to let standard WIP transactions trigger the relief automatically, or to use supported open interfaces. Any custom code that must interact with planning relief should treat MRP_RELIEF_INTERFACE as the integration point and observe the sequencing conventions established by MRP_RELIEF_INTERFACE_S. The package is documented for EBS 12.1.1 and 12.2.2 with identical procedure signatures, and its header history shows it has remained stable since the 11i era.