Search Results wsh_inbound_util_pkg




Overview
Explore in AI Chat

Overview

WSH_INBOUND_UTIL_PKG is a utility package in the Oracle E-Business Suite Applications (APPS) schema that supports inbound logistics processing within the Oracle Shipping (WSH) module. In Oracle EBS 12.1.1 and 12.2.2, the WSH module governs outbound and inbound shipment execution, delivery management, trip planning, and integration with Receiving (RCV), Order Management (OE), and Warehouse Management (WMS). WSH_INBOUND_UTIL_PKG is classified as an OTHER API in the ETRM repository and holds VALID status, indicating it is a functional component of the shipping code base rather than a public, documented open interface.

The package provides reusable helper logic consumed by higher-level inbound processing programs, particularly those dealing with drop shipments, inbound delivery splitting, routing responses, and License Plate Number (LPN) handling. It operates primarily as an internal utility layer, invoked by sibling packages rather than called directly by end users.

Key Procedures and Functions

The package exposes eight documented procedures and functions, each addressing a distinct inbound logistics concern:

  • GET_PO_RCV_ATTRIBUTES — Retrieves purchase order and receiving attributes required to validate or populate inbound shipment and receipt data.
  • GET_DROP_SHIP_INFO — Returns drop shipment information, allowing the inbound flow to identify shipments sourced directly from a supplier to a customer without passing through inventory.
  • SPLIT_INBOUND_DELIVERY — Performs the logic to split an inbound delivery into multiple deliveries, typically driven by routing, quantity, or organizational criteria.
  • RERATEDELIVERIES — Recalculates or re-rates deliveries, supporting rate and routing adjustments during inbound processing.
  • SETTRIPSTOPSTATUS — Updates the status of a trip stop, keeping trip and stop records synchronized with downstream delivery events.
  • CONVERT_QUANTITY — Converts quantities between units of measure, ensuring consistent quantity representation across item, delivery, and receipt records.
  • GET_OUTERMOST_LPN — Identifies the outermost License Plate Number for a given container hierarchy, essential for WMS-integrated inbound and LPN-driven receiving.
  • IS_ROUTING_RESPONSE_SEND — Determines whether a routing response has been sent, used to gate or trigger routing-related processing.

Tables Accessed

The package reads and writes to a defined set of tables through APPS synonyms, reflecting its role across shipping, order management, and receiving:

Usage Notes

WSH_INBOUND_UTIL_PKG is an internal shipping utility and is not intended as a standalone public API. It is referenced by eight other packages, including WSH_ASN_RECEIPT_PVT, WSH_BULK_PROCESS_PVT, WSH_IB_TXN_MATCH_PKG, WSH_IB_UI_RECON_GRP, WSH_PO_CMG_PVT, WSH_RCV_CORR_RTV_TXN_PKG, WSH_ROUTING_REQUEST, and WSH_VENDOR_PARTY_MERGE_PKG, and it also references OE_WSH_BULK_GRP and WSH_UTIL_CORE.

Invocation typically occurs indirectly through inbound shipment, ASN receipt, bulk processing, routing, and reconciliation flows, as well as through shipping forms and concurrent programs that call these dependent packages. Customizations should invoke the documented dependent packages rather than WSH_INBOUND_UTIL_PKG directly, and any direct calls must respect the assumed validation, LPN, and quantity-conversion context maintained by the calling layer.