Search Results set_rec

Overview

APPS.OE_SET_UTIL is a utility package within the Oracle E-Business Suite Order Management (OM) module. Its business function is to support the creation, manipulation, and validation of order line sets — logical groupings of order lines that must be processed together for fulfillment, shipping, arrival, and invoicing purposes. Order sets allow customers and internal operations to bundle related lines so that Order Management can generate coordinated delivery, shipment, and invoice groupings. OE_SET_UTIL encapsulates the reusable logic behind set derivation, including automatic set creation from item-level set attributes, fulfillment set generation, split/merge handling, and set attribute validation.

The package is classified as an API/utility object (API classification: UTIL) and is referenced by 20 other OM packages, indicating it serves as a foundational building block for higher-level order capture and line-processing routines such as OE_ORDER_PUB and the line processing engine. Typical callers invoke OE_SET_UTIL when an order is saved or booked, when sets must be derived from fulfillment preferences defined on the item (MTL_SYSTEM_ITEMS_B), or when a set must be created, updated, or validated during order line maintenance.

Key Procedures and Functions

• SET_EXIST — Determines whether a set already exists, available in overloaded forms keyed either by set name/set type/header or by set identifier.
• GET_FULFILLMENT_LIST — Retrieves the fulfillment sets associated with a given order line.
• GET_SET_ID — Returns the identifier of a set for the provided context.
• PROCESS_SETS — Core driver that inspects set requests and populates the global tables read during order line processing.
• CREATE_SET — Creates a new set record.
• INSERT_INTO_SET — Inserts a line into an existing set.
• SPLIT_SET — Splits a set into multiple sets, typically during line splits or partial processing.
• UPDATE_SET — Updates set attributes.
• GET_SET_REC — Returns the cached set record for a line.
• VALIDATE_SET_ATTRIBUTES — Validates set attributes against defined rules.
• VALIDATE_MULTI_ARR_SET — Validates multi-arrival sets.
• UPDATE_OPTIONS — Updates set options for a set.
• QUERY_SET_ROWS — Queries set rows for a given set.
• CREATE_LINE_SET — The routine matching the user's search; creates a line-level set for an order line.
• REMOVE_FROM_FULFILLMENT — Removes a line from a fulfillment set.
• CREATE_FULFILLMENT_SET — Creates a fulfillment set derived from fulfillment preferences.
• DEFAULT_LINE_SET — Applies default set values to a line.
• DELETE_SET — Deletes a set.
• STAND_ALONE_SET_EXISTS — Checks whether a stand-alone set exists for a line.

The package also declares several record and table types (SET_REC, SET_OPT_REC, AUTO_SET_REC) and globals (G_SET_TBL, G_SET_OPT_TBL, G_AUTO_SET_TBL) used to cache set state during processing.

Tables Accessed

Through APPS synonyms, OE_SET_UTIL reads and writes: OE_SETS and OE_SETS_S (set definitions), OE_LINE_SETS (line-to-set associations), OE_ORDER_LINES and OE_ORDER_LINES_ALL (order line data and attribute propagation), MTL_SYSTEM_ITEMS_B (item-level fulfillment syntax used to derive default sets), WSH_DELIVERY_ASSIGNMENTS, WSH_DELIVERY_DETAILS, WSH_NEW_DELIVERIES, and WSH_SHIPPING_PARAMETERS (shipping/delivery context for fulfillment and arrival sets), plus DUAL and PLITBLM (PL/SQL global temporary tables used for query joins).

Usage Notes

OE_SET_UTIL is not a standalone public API; it is invoked internally by Order Management line-processing packages during order save, booking, and fulfillment activities. Custom code should generally call higher-level APIs such as OE_ORDER_PUB rather than OE_SET_UTIL directly. Forms such as the Sales Orders window and concurrent programs (e.g., order import, fulfillment set generation) may trigger its routines indirectly. Customizations requiring direct set manipulation — for example, programmatically creating a line set — should use CREATE_LINE_SET or CREATE_FULFILLMENT_SET in accordance with the sequence used by the standard processing engine.