Search Results get_min_max_quantity_uom




Overview
Explore in AI Chat

Overview

OE_SHIPPING_TOLERANCES_PUB is a public PL/SQL API within the Oracle Order Management module of Oracle E-Business Suite. Its business purpose is to determine the shipping tolerance quantities applicable to an order line, specifically the minimum and maximum quantities that remain to be shipped before the line is considered complete. Shipping tolerances allow organizations to define acceptable variances — under-shipment or over-shipment — relative to the ordered quantity on a sales order line. Rather than exposing this logic solely through internal validation routines, Oracle provides this package as a published API so that external processes, forms, and custom extensions can programmatically retrieve tolerance values for a given line. The package is classified as PUB, meaning it forms part of the supported public interface surface and is intended for direct invocation by customer and partner code. The header comment in the source confirms the API is designed to return the minimum and maximum remaining quantity to be shipped for a line, taking only a line identifier and API version as required inputs.

Key Procedures and Functions

The package exposes two documented procedures, both centered on retrieving remaining quantity tolerances for an order line.

  • GET_MIN_MAX_TOLERANCE_QUANTITY — Returns the minimum and maximum remaining quantities to be shipped for the specified order line. It provides two pairs of output values, supporting a secondary quantity (Quantity2) that accommodates Oracle Process Manufacturing (OPM) dual-unit-of-measure scenarios. Standard return status, message count, and message data outputs are included for error handling consistent with other Order Management public APIs.
  • GET_MIN_MAX_QUANTITY_UOM — Performs the same tolerance retrieval function but additionally returns the unit of measure associated with each quantity. It supplies the primary remaining quantity range and its UOM, plus the secondary quantity range and its corresponding UOM, along with the standard return status, message count, and message data outputs. This variant is preferred when the calling process requires the UOM alongside the numeric tolerance values, avoiding a separate lookup.

Tables Accessed

The package reads from two documented tables through APPS synonyms:

  • OE_ORDER_LINES_ALL — The primary source of order line data. The tolerance logic requires attributes such as the ordered quantity, shipped quantity, line unit of measure, and tolerance configuration to compute the minimum and maximum remaining quantities.
  • WSH_DELIVERY_DETAILS — Provides shipping and delivery detail records associated with the line, allowing the API to account for quantities already assigned to deliveries or shipments when determining what remains.

Usage Notes

This package is typically invoked during order line validation, shipping confirmation, and fulfillment processing, where the system must determine whether a line has been shipped within its allowed tolerance bounds or whether additional shipment is still permitted. It is referenced by at least one other package within the EBS codebase, indicating it serves as a shared utility for tolerance calculations. Custom code, order import routines, and extensions that need to enforce or report on shipping tolerances can call GET_MIN_MAX_TOLERANCE_QUANTITY or GET_MIN_MAX_QUANTITY_UOM directly. Callers must supply a valid API version number and a line identifier. Because both procedures include standard return status and message outputs, invoking code should always inspect x_return_status and process any returned messages before relying on the quantity outputs, particularly in the dual-quantity OPM context where both Quantity and Quantity2 values must be evaluated.