Search Results inv_delay_shipment

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:

Ship method and carrier resolution: GET_SHIPMETHOD_MEANING, VALIDATE_SHIP_METHOD, GET_VALID_CARRIER, GET_SHIP_METHOD_LOV — used to resolve, validate, and present shipping method and carrier information for user selection and transaction validation.
Delivery retrieval and validation: GET_VALID_DELIVERY, GET_VALID_DELIVERY_VIA_LPN, GET_VALID_DELIVERY_LINE, GET_DELIVERY_INFO, INV_DELIVERY_LINE_INFO — retrieve delivery and delivery-line details and validate that a given delivery or line is eligible for shipping activity.
Serial number handling: SERIAL_AT_SALES_CHECK, GET_DELIVERY_LINE_SERIAL_INFO — validate serial-controlled item behavior at sales order stage and report serial information for a delivery line.
Trip and dock operations: GET_TRIP_NAME, GET_TRIP_LOV, GET_DOCK_DOOR — supply trip and dock door values used in shipping and load execution.
LPN operations: GET_ITEMS_IN_LPN — enumerate the items contained within a license plate number.
Inventory reversal operations: INV_RETURN_TO_STOCK, INV_LINE_RETURN_TO_STOCK, INV_DELAY_SHIPMENT, INV_REPORT_MISSING_QTY — reverse or adjust shipping transactions, returning goods to stock, delaying shipment, or reporting discrepancies in shipped quantity.
Submission: SUBMIT_DELIVERY_LINE — submits a delivery line for processing.

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:

Inventory master data: MTL_SYSTEM_ITEMS_B and MTL_SYSTEM_ITEMS_KFV (item validation and description flexfield), MTL_TRANSACTION_TYPES (valid transaction types), MTL_INTERORG_PARAMETERS (organization-level shipping controls).
Unit-of-measure conversion: MTL_UOM_CLASS_CONVERSIONS, MTL_LOT_UOM_CLASS_CONVERSIONS — quantity conversions during shipping validation.
Transaction and serial data: MTL_MATERIAL_TRANSACTIONS_S, MTL_SERIAL_NUMBERS_TEMP — transactional and serial tracking.
Order and requisition sources: OE_ORDER_LINES_ALL, OE_SETS (order lines and default sets), PO_REQUISITION_LINES_ALL (requisition-originated shipments).
WMS and carrier data: WMS_LICENSE_PLATE_NUMBERS, WMS_SHIPPING_TRANSACTION_TEMP, WSH_CARRIERS, WSH_CARRIER_SERVICES — LPN, staging, and carrier service definitions.

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.