Search Results inv_shipping_transaction_pub




Overview
Explore in AI Chat

Overview

APPS.INV_SHIPPING_TRANSACTION_PUB is a public PL/SQL package in the Oracle E-Business Suite Inventory (INV) module that encapsulates the business logic governing outbound shipping transactions. It is the public interface (API classification PUB) for validating, retrieving, and executing shipping-related activities such as delivery validation, carrier and ship method lookup, license plate number (LPN) contents, serial number handling, and return-to-stock operations. The package sits at the boundary between Inventory, Order Management, Purchasing, and Warehouse Management System (WMS) functionality, providing a controlled, reusable API layer rather than allowing direct table manipulation of shipping data.

Within the Oracle EBS 12.1.1 and 12.2.2 releases, the object is marked VALID in the APPS schema. It depends on the standard Oracle foundation packages FND_API and SYS.STANDARD, confirming that it follows the EBS API design conventions (standard return status, message stack handling, and exception propagation) rather than exposing raw PL/SQL errors to callers.

Key Procedures and Functions

The package exposes 42 documented procedures and functions. The principal groups are as follows:

These procedures are designed for use by other EBS packages rather than being self-contained screens, which is consistent with their PUB designation.

Tables Accessed

The package reads and writes through APPS synonyms covering inventory, order management, purchasing, and WMS tables:

Usage Notes

INV_SHIPPING_TRANSACTION_PUB is referenced by four packages documented in ETRM: GML_MOBILE_SHIP_CONFIRM, WMS_CONSOLIDATION_PUB, WMS_DIRECT_SHIP_PVT, and WMS_SHIPPING_TRANSACTION_PUB, as well as by itself. This dependency structure shows it is a foundational API invoked by WMS consolidation, direct shipment, and mobile shipping confirmation flows.

Typical invocations occur from Oracle Inventory and Warehouse Management forms, shipping confirmation concurrent programs, mobile (RF) shipping applications, and custom extensions that need to validate a delivery, resolve an LPN, or return goods to stock. Custom callers must respect the package's FND_API conventions — capturing the returned status and reading the message stack rather than relying on exceptions — and should not modify the underlying tables directly. Because the package references WSH_CARRIERS, WSH_CARRIER_SERVICES, and WMS_LICENSE_PLATE_NUMBERS, its use presumes Oracle Shipping Execution and Warehouse Management are installed and licensed. In 12.2.2, the same public interface remains valid, making this package a stable integration point across both releases.