Search Results wsh_new_deliveries

Overview

The WSH_NEW_DELIVERIES table is the central transactional table for the delivery entity within the Oracle E-Business Suite Shipping Execution (WSH) module. It stores the master record for every delivery created in the system, serving as the primary hub for managing the shipment of order lines to customers. A delivery is a logical grouping of order lines that are shipped together. This table is critical for the order-to-cash cycle, linking sales orders from Order Management (OM) to physical shipping activities, freight costing, and invoicing. Its role is to define the shipment's attributes, status, and relationships, enabling the planning, execution, and tracking of outbound logistics.

Key Information Stored

While the specific column list is not detailed in the provided metadata, the primary and foreign key relationships define its core structure. The table is uniquely identified by the DELIVERY_ID (Primary Key: WSH_DELIVERIES_PK). A critical foreign key is PARTY_ID, which references HZ_PARTIES, linking the delivery to the customer (ship-to) party. Based on standard WSH table structures, other significant columns typically include STATUS_CODE to track the delivery lifecycle (e.g., OP, CL), NAME for the delivery identifier, INITIAL_PICKUP_DATE and LATEST_PICKUP_DATE for scheduling, and various IDs linking to carriers (CARRIER_ID), freight codes, and source documents. The table holds administrative information such as CREATION_DATE and LAST_UPDATE_DATE.

Common Use Cases and Queries

This table is fundamental for shipping operations and reporting. Common use cases include generating delivery reports, tracking delivery status, and troubleshooting shipping transactions. A frequent query pattern joins WSH_NEW_DELIVERIES to related tables to get a comprehensive delivery view. For instance, to list open deliveries with their associated customer name:

• SELECT d.NAME, d.STATUS_CODE, hzp.PARTY_NAME FROM WSH_NEW_DELIVERIES d, HZ_PARTIES hzp WHERE d.PARTY_ID = hzp.PARTY_ID AND d.STATUS_CODE = 'OP';

Another critical pattern involves linking deliveries back to their source order lines via the WSH_DELIVERY_ASSIGNMENTS table. This is essential for understanding which sales order fulfillments are grouped into a specific shipment. The table is also central to interfaces with Warehouse Management Systems (WMS) and transportation management, as indicated by the foreign key relationship with WMS_SHIPPING_TRANSACTION_TEMP.

Related Objects

The metadata reveals extensive integration points. Key related objects include:

• WSH_DELIVERY_ASSIGNMENTS: Directly links deliveries to the specific shipped order lines (and can reference WSH_NEW_DELIVERIES twice for parent-child delivery hierarchies).
• WSH_DELIVERY_LEGS: Stores the multi-leg routing details for a delivery.
• WSH_FREIGHT_COSTS: Holds freight charges associated with the delivery.
• WSH_NEW_DEL_INTERFACE & WSH_DEL_ASSGN_INTERFACE: Interface tables for creating and updating deliveries and their assignments.
• OE_INVOICE_NUMBERS: Links deliveries to their corresponding invoices in Receivables.
• JAI_* Tables: Multiple India Localization tables reference DELIVERY_ID for tax and regulatory compliance (e.g., JAI_CMN_OM_AR_AR3_FORMS).
• WSH_EXCEPTIONS & WSH_PICKING_BATCHES: For managing shipping holds and batch pick releases.