Search Results schedule_set

Overview

APPS.OE_GROUP_SCH_UTIL is a utility package within the Oracle Order Management (OM) module of Oracle E-Business Suite, and it is classified in the ETRM repository as an API UTIL object. Its primary business function is to support the scheduling of order lines and, in particular, the scheduling of order line sets — groupings of related lines that must be scheduled together as a scheduling set. The package name itself reflects this scope: "Group Schedule Utility." It provides the shared scheduling logic that higher-level APIs and forms in Order Management call when lines need to be scheduled, either individually, in selected batches, or as part of a scheduling set.

The package is registered in ETRM with a documented footprint of eight procedures and functions, references the standard Order Management and inventory tables through APPS synonyms, and is referenced by five other packages. The source header indicates a last revision date of 16 January 2007, with the code base reflecting the R12 multi-org access control (MOAC) changes, as evidenced by the use of OE_GLOBALS.Selected_Record_Tbl in the multi-line scheduling routine.

Key Procedures and Functions

• Schedule_Order — Schedules a single order header identified by its header identifier, applying a specified scheduling action. It returns ATP results along with the standard return status, message count, and message data outputs.
• Schedule_Multi_Lines — Schedules multiple selected order lines in a single call, using the R12 MOAC-compatible selected-record table to identify the lines. Like Schedule_Order, it returns an ATP table plus the standard status and message outputs.
• Schedule_Set — Schedules a set of lines represented through the OE_ORDER_PUB request record structure, returning the standard return status.
• Schedule_Set_Lines — Schedules the lines belonging to a scheduling set, accepting a request table and returning the standard return status.
• Validate_Group — Validates a group of lines prior to or during scheduling. It accepts an in/out line table and a scheduling action, with a validation action defaulting to 'PARTIAL'. This default was added for Bug 3590437.
• Find_Line — A function added for Bug 2454163 that searches a line table for a specific line identifier and returns a Boolean result.
• Group_Schedule_Sets — Processes scheduling for a collection of scheduling sets supplied through the request table, returning the standard return status.
• Validate_Item_Warehouse — Appears in the documented procedure list; it performs item-and-warehouse validation associated with scheduling, ensuring that the item and warehouse combination is valid before scheduling proceeds.

The package also declares supporting PL/SQL types, including NUMBER_ARR, a set_rec_type record (carrying line_id, ship_set_id, and arrival_set_id), and set_Tbl_Type, which are used internally to represent scheduling sets.

Tables Accessed

• MTL_SYSTEM_ITEMS_B — Read to validate item attributes and the item–warehouse relationship during scheduling and validation. This supports the Validate_Item_Warehouse logic.
• OE_ORDER_LINES_ALL — The central order line table, read and updated as line scheduling attributes and set memberships are processed.
• PLITBLM — A PL/SQL index-by table synonym used as an in-memory structure for set manipulation and line collection handling within scheduling operations.

Usage Notes

OE_GROUP_SCH_UTIL is an internal utility that is typically invoked indirectly. The Order Management scheduling forms, the Order Organizer, and higher-level public APIs such as OE_ORDER_PUB call into this package when a user or program requests scheduling of an order, selected lines, or a scheduling set. Because ETRM records that five packages reference OE_GROUP_SCH_UTIL, custom extensions should prefer invoking the supported OE_ORDER_PUB APIs rather than calling this utility directly.

When called from custom code, the standard return-status and message-count/message-data parameters must be checked to interpret success or failure, and the MOAC-compatible selected-record table must be populated appropriately for multi-line scheduling in R12.1.1 and 12.2.2 environments.