Search Results reserved_quantity2




Overview
Explore in AI Chat

Overview

OE_RSCH_SETS_CONC_REQUESTS is an Oracle E-Business Suite Order Management (OM) package body owned by APPS that supports the scheduling and rescheduling of "sets" of order lines. A set is a group of related order lines that must be scheduled together so that their availability-to-promise (ATP) results remain consistent and their ship-set integrity is preserved. The package coordinates the concurrent processing logic needed to (re)schedule the constituent lines of an order set as a single logical unit of work rather than scheduling each line independently.

Internally the package exposes the procedure Schedule_set_of_lines, which acts as a thin intermediary between the Sets API and the core scheduling routine Process_Set_of_lines. Its design intent, as documented in the source comments, is to give the Sets API a dedicated hook where set-specific validation or logic could be inserted without impacting the shared scheduling path. The procedure iterates over the incoming line table, skips service items and "included" items (which inherit scheduling from their parent line), and forwards the remaining lines for ATP processing.

Key Procedures and Functions

The ETRM metadata documents a single entry point for this package:

  • RESCHEDULE_SHIP_SET — The documented procedure associated with this package in the 12.2.2 inventory. It handles the rescheduling of a ship set, re-evaluating scheduling for the lines that belong to that set. Consistent with the package's design, it does not schedule lines in isolation; it operates on the set as a whole so that the lines remain synchronized.

The package body also contains the internal helper Schedule_set_of_lines, which validates the supplied line table, ignores service and included items, and passes the request to Process_Set_of_lines for ATP scheduling. Detailed parameter lists for these routines should be taken from the source definition and are not reproduced here.

Tables Accessed

The package reads and writes order data through the following APPS synonyms:

  • OE_ORDER_HEADERS — Order header context for the set being scheduled or rescheduled.
  • OE_ORDER_LINES / OE_ORDER_LINES_ALL — The line-level records that make up the ship set, including scheduling and shipping attributes.
  • OE_SETS — Defines the set membership linking the related lines that must be scheduled together.
  • PLITBLM — The PL/SQL table of line identifiers passed between the Sets API and the scheduling logic.

These tables provide the set definition and line attributes required to determine which lines participate in scheduling and to persist the resulting scheduling dates and quantities.

Usage Notes

This package is normally invoked indirectly by the Order Management scheduling and sets APIs rather than called directly by end users. It is triggered when a ship set is created, modified, or rescheduled through standard OM flows, and its concurrent-request orientation makes it suitable for background processing of set scheduling. Customizations should call the supported Sets and Scheduling public APIs rather than this internal package. References to the legacy reserved_quantity2 column reflect the older inventory/scheduling schema; review its use in any custom logic against current 12.1.1 and 12.2.2 column semantics, since it remains in the set-scheduling data path for backward compatibility.