Search Results wsh_delivery_details




Overview
Explore in AI Chat

Overview

WSH_DELIVERY_DETAILS is the core transactional table of Oracle Shipping Execution (WSH) in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the individual delivery lines that make up a shipment: each row represents a single shippable line, carrying the item, quantities, sourcing document references, shipping attributes, and container/LPN context required to plan, pick, pack, ship, and confirm a delivery. The table is owned by the WSH schema and, in the documented 12.2.2 physical schema, contains 210 columns with a single documented unique index, WSH_DELIVERY_DETAILS_U1 (DELIVERY_DETAIL_ID), alongside the primary key constraint WSH_DELIVERY_DETAILS_PK.

The table functions as the operational intersection between order capture (OE), inventory (INV), receiving (RCV), and shipping execution. Rows originate from order lines, returns, transfer orders, and internal requisitions, and are progressively updated as the delivery moves through pick release, ship confirm, and inventory interface. The metadata’s heuristic Data Vault classification is hub-leaning, meaning DELIVERY_DETAIL_ID behaves primarily as a durable business entity key; in a Data Vault model this would typically be represented as a hub with associated satellites for the mutable quantity, status, and container attributes. This classification is a modeling suggestion, not a physical constraint in EBS.

Key Information Stored

The surrogate primary key is DELIVERY_DETAIL_ID, which uniquely identifies each delivery line and is the column referenced by nearly every dependent WSH, WMS, and India localization (JAI) table. There is no separate documented business-key unique index beyond this identifier, so external document references act as natural business keys rather than enforced uniqueness.

Common Use Cases and Queries

Typical reporting and troubleshooting scenarios include tracing which order lines belong to a given delivery, checking pick/ship progress, and reconciling ship-confirm quantities against inventory.

To list all delivery lines for a shipment and join to the delivery assignment:

  • SELECT d.delivery_detail_id, d.source_line_number, d.inventory_item_id, d.requested_quantity, d.shipped_quantity, d.released_status FROM wsh_delivery_details d WHERE d.source_header_id = :order_header_id;
  • SELECT da.delivery_id, d.delivery_detail_id, d.inventory_item_id, d.delivered_quantity FROM wsh_delivery_details d, wsh_delivery_assignments da WHERE d.delivery_detail_id = da.delivery_detail_id AND da.delivery_id = :delivery_id;

Other practical uses: identifying unpicked lines via PICKABLE_FLAG = 'Y' and RELEASED_STATUS; finding split lines by querying SPLIT_FROM_DELIVERY_DETAIL_ID; and auditing interface failures through OE_INTERFACED_FLAG or INV_INTERFACED_FLAG. Reconciliation queries frequently join to MTL_MOVEMENT_STATISTICS through MOVEMENT_ID and to WMS_LPN_CONTENTS through LPN_CONTENT_ID.

Related Objects

The table participates in an extensive FK network. The most significant related objects include:

Because of its hub role and central FK position, any extract or replication of shipping data should treat DELIVERY_DETAIL_ID as the stable entity key and expect its mutable attributes to change frequently across the pick-to-ship lifecycle.