Search Results get_min_max_tolerance_quantity

Overview

APPS.OE_SHIPPING_TOLERANCES_PUB is a public PL/SQL API package in Oracle Order Management that calculates shipping tolerance boundaries for order lines. Shipping tolerances define the permissible over-shipment and under-shipment percentages (or quantities) that a warehouse may apply when fulfilling a sales order line, and they are a prerequisite for order line shipping and delivery activities. Rather than requiring callers to re-implement the tolerance arithmetic, this package centralizes the logic and returns the minimum and maximum remaining quantities that may still be shipped against a given line.

The package body carries a header date of 2005 and identifies itself internally as OE_Shipping_Tolerances_PUB, version 1.0. It is classified as a PUB (public) API within the ETRM catalog for both EBS 12.1.1 and 12.2.2, meaning its signature is treated as an integration surface supported for direct invocation. The body includes a modification note indicating that a second quantity value was added for OPM (Oracle Process Manufacturing) support, so tolerance results are returned in parallel for both discrete and process manufacturing contexts.

Key Procedures and Functions

• GET_MIN_MAX_TOLERANCE_QUANTITY — The primary documented procedure and the object users most commonly search for. It accepts a line identifier and returns the minimum and maximum remaining quantities that may be shipped for that line, computed by applying the shipping tolerance above and below percentages against the ordered and already-shipped quantities. The body declares local variables for the line set, tolerance percentages above and below, ordered, shipped and shipping quantities, and the derived minimum and maximum remaining quantities. It also returns a parallel pair of quantity values for OPM, plus the standard API return status, message count, and message data outputs used throughout Oracle's public APIs.
• GET_MIN_MAX_QUANTITY_UOM — A companion procedure that resolves the unit of measure associated with the minimum and maximum tolerance quantities for a line, ensuring that callers receive results in the correct ordered or shipping UOM rather than in a raw numeric form. This is essential where the ordered quantity UOM and the shipping quantity UOM differ.

Tables Accessed

The package reads from two core Order Management and shipping tables through APPS synonyms:

• OE_ORDER_LINES_ALL — Supplies the ordered quantity, shipped quantity, shipping quantity, line set identifier, order quantity UOM, shipping quantity UOM, and the top model and ATO line context used to resolve configurations. The shipping tolerance percentages are also sourced here per line set.
• WSH_DELIVERY_DETAILS — Provides shipped and delivered quantities from the delivery side so that the tolerance calculation reflects actual shipment activity, not only order-line counters.

Usage Notes

OE_SHIPPING_TOLERANCES_PUB is invoked when a caller needs to determine how much of a line remains available for shipment before violating tolerance rules. Typical callers are shipping and delivery forms, line-level shipping execution logic, pick-release validation code, and custom extensions or concurrent programs that pre-validate quantities. The package is documented as referenced by one other package, indicating reuse inside the Order Management stack itself. Because it is a PUB API, custom code should call it rather than querying OE_ORDER_LINES_ALL and WSH_DELIVERY_DETAILS directly, and should always check x_return_status before consuming the returned quantities. Callers working with process manufacturing lines should read the second pair of quantity outputs, while discrete lines use the first pair.