Search Results get_fulfillment_eligible

Overview

APPS.OE_DUAL_UOM_UTIL is a utility package body in Oracle E-Business Suite Order Management (OM) that supports dual unit of measure (dual UOM) processing on order lines. Its central business purpose is to determine whether the fulfillment base quantity for an order line should be calculated, and to derive and validate that value against the item's defined units of measure. The package was delivered as part of the dual UOM functionality introduced in the 12.1.x and 12.2.x release streams; the header ($Header: OEXUDUMB.pls 120.0.12020000.8) indicates shipset maintenance through the 12.2 code line. The package is classified as a UTIL package in the ETRM repository, is owned by APPS, and contains four documented procedures and functions.

The package operates only when the profile option "OM: Default Fulfillment Base" is set to YES and a warehouse has been assigned to the line. Its responsibilities complement the broader fulfillment base derivation logic: it qualifies individual order lines, loads the relevant inventory item attributes, performs the arithmetic to convert between the primary and secondary (dual) units of measure, and validates the resulting fulfillment base quantity.

Key Procedures and Functions

• GET_FULFILLMENT_ELIGIBLE — The entry point queried by callers searching for eligibility logic. It accepts an OE_Order_PUB.Line_Rec_Type record (carrying the line identifier) and returns a BOOLEAN indicating whether the fulfillment base should be calculated for that line. It returns TRUE only when the ordered item is a dual UOM item and is shippable, reservable, or an inventory item in the master item definition. The documented logic references MTL_SYSTEM_ITEMS attributes RESERVABLE_TYPE (1 = reservable, 2 = non-reservable) and INVENTORY_ITEM_FLAG (Y = inventory item, N = not an inventory item). It also supplies an OUT NOCOPY record (Inventory_Item_Rec_Type) containing item properties, including the primary UOM, for later use by DERIVE_FULFILLMENT_BASE.
• GET_FULFILLMENT_BASE — Retrieves the fulfillment base value applicable to the order line, providing the quantity basis used by downstream dual UOM processing.
• DERIVE_FULFILLMENT_BASE — Performs the derivation of the fulfillment base quantity for a line, consuming the profile verification, warehouse check, and item attributes established earlier in the flow.
• VALIDATE_FULFILLMENT_BASE — Confirms that a candidate fulfillment base value is valid for the line and its item, guarding against inconsistent or ineligible quantities before they are written back to the order line.

Tables Accessed

The package reads and writes through APPS synonyms for the following documented tables. MTL_SYSTEM_ITEMS and MTL_SYSTEM_ITEMS_B are queried to fetch item properties, including unit of measure and the shippable, reservable, and inventory item flags that drive eligibility. MTL_UNITS_OF_MEASURE provides UOM definitions and conversion relationships required to convert between primary and dual units. MTL_PARAMETERS supplies organizational inventory parameters, including the warehouse/organization context. OE_ORDER_LINES and OE_ORDER_LINES_ALL hold the order line records against which fulfillment base values are derived and validated.

Usage Notes

OE_DUAL_UOM_UTIL is an internal utility invoked by Order Management processing rather than a standalone end-user API. It is referenced by 13 other packages in the ETRM repository, indicating that the Order Management order-entry and line-processing flows call it during line save, pricing, and shipping preparation to populate and validate fulfillment base quantities. It is typically triggered from the Sales Orders and Order Organizer forms, from order import and other concurrent programs, and indirectly from custom extensions that invoke OE_Order_PUB. Because OM: Default Fulfillment Base must be YES and a warehouse must be present, the utility is a no-op in environments where dual UOM is not enabled. Custom code should not bypass the package's eligibility and validation checks when manipulating fulfillment base values directly.