Search Results wsh_delivery_assignments

Overview

The WSH_DELIVERY_ASSIGNMENTS table is a core data object within the Oracle E-Business Suite Shipping Execution (WSH) module for versions 12.1.1 and 12.2.2. It functions as the transactional ledger for the assignment of delivery details (individual lines) to delivery documents. This table is fundamental to the process of building shipments, as it records the specific allocation of order lines or other source lines to a delivery, which is the primary shipping document. It manages the complex, often many-to-many, relationship between delivery details and deliveries, enabling scenarios where a single line can be split across multiple deliveries or multiple lines can be consolidated into one.

Key Information Stored

The table's primary key is DELIVERY_ASSIGNMENT_ID, which uniquely identifies each assignment record. Its most critical columns are the foreign keys that define the relationships between entities. The DELIVERY_DETAIL_ID column links to the WSH_DELIVERY_DETAILS table, identifying the specific line item being assigned. The DELIVERY_ID column links to the WSH_NEW_DELIVERIES table, identifying the target delivery document. For complex assignment scenarios involving splits or consolidations, the PARENT_DELIVERY_DETAIL_ID and PARENT_DELIVERY_ID columns track the original source detail and delivery, respectively, maintaining a clear audit trail of the assignment history.

Common Use Cases and Queries

A primary use case is tracing the fulfillment path of a sales order line. Developers and support analysts query this table to determine which delivery and subsequent shipment an order line was assigned to. Common reporting needs include listing all lines within a specific delivery or finding all deliveries associated with a particular source line. A typical diagnostic query would join WSH_DELIVERY_ASSIGNMENTS to WSH_DELIVERY_DETAILS and WSH_NEW_DELIVERIES.

• Sample Query: SELECT dda.delivery_detail_id, dda.delivery_id, nd.name delivery_name FROM wsh_delivery_assignments dda, wsh_new_deliveries nd WHERE dda.delivery_id = nd.delivery_id AND nd.delivery_id = :p_delivery_id;
• Integration Point: The data in this table is often leveraged in custom shipping reports, carrier integration logic, and inventory interface programs to confirm what has been staged for shipment.

Related Objects

WSH_DELIVERY_ASSIGNMENTS has direct foreign key relationships with two other central WSH tables, as documented in the ETRM.

• WSH_DELIVERY_DETAILS: Linked via DELIVERY_DETAIL_ID and PARENT_DELIVERY_DETAIL_ID. This table holds the source lines from Order Management, Inventory, or other modules.
• WSH_NEW_DELIVERIES: Linked via DELIVERY_ID and PARENT_DELIVERY_ID. This is the main delivery document header table.

While not listed in the provided metadata, this table is also integral to the public APIs in the WSH_DELIVERIES_PUB package, which are used to programmatically create and manage deliveries and their assignments. Direct manipulation of this table outside of these supported APIs is strongly discouraged.