Search Results wsh_new_deliveries




Overview
Explore in AI Chat

Overview

WSH.WSH_NEW_DELIVERIES is the central master table for delivery header information in the Oracle E-Business Suite Shipping Execution module (WSH). In both 12.1.1 and 12.2.2, this table stores one row per delivery, capturing the full lifecycle of an outbound shipment — from planned pickup through confirmed dispatch, advance ship notice (ASN) transmission, and final drop-off. It is the anchor point for the entire delivery data model, holding header-level attributes that govern freight terms, carrier selection, weight and volume, routing, workflow progress, and Transportation Management (TMS) integration.

The table carries 157 documented columns against primary key WSH_DELIVERIES_PK (DELIVERY_ID), and unique index WSH_NEW_DELIVERIES_U2 (NAME) establishes the delivery name as the business-key candidate. From a Data Vault modeling perspective, the heuristic classification mined from the foreign-key structure is hub: WSH_NEW_DELIVERIES is referenced by many dependent tables via DELIVERY_ID, making it a natural business-key anchor around which link and satellite constructs would be built. This classification is a modeling suggestion rather than a physical implementation.

Key Information Stored

The most significant columns include:

Common Use Cases and Queries

Typical reporting scenarios include open-delivery dashboards, on-time shipment analysis, ASN reconciliation, and carrier performance measurement. A common query lists deliveries by status and customer:

  • SELECT d.delivery_id, d.name, d.status_code, d.confirm_date, c.customer_name FROM wsh_new_deliveries d, ra_customers c WHERE d.customer_id = c.customer_id AND d.status_code = 'CLOSED' AND d.organization_id = :org_id;
  • Joining delivery headers to their detail lines via WSH_DELIVERY_ASSIGNMENTS.DELIVERY_ID to trace delivery lines and inventory transactions.
  • Aggregating WSH_FREIGHT_COSTS by delivery for landed-cost and freight accrual reporting.
  • Filtering SHIPMENT_DIRECTION to isolate inbound (RCV) versus outbound deliveries for logistics KPIs.
  • Exposing custom ATTRIBUTE columns through the DFF for customer-specific reporting.

Related Objects

The most commonly used public APIs against this data are the Shipping Execution delivery APIs and the Delivery Workflow (DELIVERY_WF_PROCESS), which drive status transitions recorded directly on this table.