Search Results schedule_orders

Overview

OE_BULK_SCHEDULE_UTIL is a utility package in the Oracle Order Management (OM) module of Oracle E-Business Suite, owned by the APPS schema and classified as a UTIL-type API. Its primary business function is to support the bulk order scheduling process — the mechanism by which large volumes of order lines are scheduled, rescheduled, and assigned inventory or ATP (Available-to-Promise) dates during high-throughput order import and processing operations. Rather than exposing a standalone user interface, this package provides internal scheduling services consumed by the higher-level bulk processing engine, most notably OE_BULK_ORDER_PVT and OE_BULK_PROCESS_LINE.

The package operates within the scheduling and ATP evaluation layer of Order Management. It supplies date derivation logic and orchestrates the temporary staging of scheduling results, enabling bulk operations to compute feasible ship dates efficiently against the scheduling engine without committing each line individually. It is available in both 12.1.1 and 12.2.2, with the documented metadata reflecting the 12.2.2 Release Update code line. Status is recorded as VALID.

Key Procedures and Functions

Two program units are documented in the ETRM metadata for this package:

• SCHEDULE_ORDERS — The principal procedural entry point. It performs the bulk scheduling of order lines, applying scheduling and ATP logic across the set of lines passed in by the calling bulk processing routine. It is the procedure responsible for driving the interaction with the scheduling/ATP temporary structures and for capturing scheduling outcomes for downstream processing.
• GET_DATE_TYPE — A supporting function used to determine or classify the date type associated with a scheduling operation, allowing the scheduling logic to distinguish among request date, schedule date, ship date, and related date semantics when computing results.

Parameter lists are not exposed in the documented metadata and should be derived from the live package specification in the deployment environment if custom integration is required.

Tables Accessed

The package references the following tables and views via APPS synonyms:

• OE_ORDER_HEADERS / OE_ORDER_HEADERS_ALL — Order header context used to establish the order-level attributes required for scheduling evaluation.
• MRP_ATP_SCHEDULE_TEMP_S — Temporary staging table used by the ATP/scheduling engine to hold schedule results during bulk evaluation.
• OE_MSG_ID_S — Sequence used to generate message identifiers for processing feedback.
• OE_PROCESSING_MSGS — Storage for error and informational messages generated during bulk scheduling.
• DUAL, PLITBLM, V$TIMER — Standard utility references used for control queries, PL/SQL index-by table conversion, and elapsed-time measurement respectively.

Usage Notes

OE_BULK_SCHEDULE_UTIL is not intended for direct invocation by end users or through standard Oracle Forms. It is internal supporting infrastructure invoked programmatically by OE_BULK_ORDER_PVT and OE_BULK_PROCESS_LINE, which are themselves driven by the Order Import and bulk order processing concurrent programs. Custom code should generally call the higher-level OE_BULK_ORDER_PVT APIs rather than this utility, since the utility assumes the calling context and setup established by those routines. The dependency graph confirms OE_BULK_ORDER_PVT both references and is referenced by this package, and the package is self-recursive, indicating internal reuse among its program units. Any modification or extension should be validated carefully, as this package participates directly in the scheduling core of high-volume order processing.