Results for “parent_delivery_id”

50+ results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

WSH_DELIVERY_ASSIGNMENTS is a Shipping Execution (WSH) table that stores the association between delivery details and the deliveries to which they are assigned. In Oracle EBS 12.1.1 and 12.2.2, this table governs the linkage between line-level delivery content (WSH_DELIVERY_DETAILS) and the header-level delivery records (WSH_NEW_DELIVERIES), including hierarchical parent-child relationships used during delivery consolidation, splitting, and repacking operations. The table is owned by the WSH schema and holds a status of VALID.

From a Data Vault modeling perspective, the documented foreign-key structure — with references to both WSH_NEW_DELIVERIES and WSH_DELIVERY_DETAILS through multiple columns — suggests this object is best classified heuristically as a link table. It records the resolution of relationships (delivery-to-detail and parent-to-child) rather than functioning as a standalone hub of business entities, and its attribute columns are largely transactional and audit-oriented.

Key Information Stored

The table contains 16 documented columns. The most significant are:

All four foreign-key columns (DELIVERY_ID, PARENT_DELIVERY_ID, DELIVERY_DETAIL_ID, PARENT_DELIVERY_DETAIL_ID) are critical for correct hierarchical reconstruction of delivery content. The surrogate key DELIVERY_ASSIGNMENT_ID should be treated as the immutable identifier, while no natural composite business key is separately documented in the provided metadata.

Common Use Cases and Queries

Typical reporting scenarios include tracing which details belong to a delivery, reconciling parent and child deliveries, and auditing delivery reassignments. A representative join pattern is:

  • Join WSH_DELIVERY_ASSIGNMENTS.DELIVERY_ID to WSH_NEW_DELIVERIES.DELIVERY_ID to retrieve delivery header context.
  • Join WSH_DELIVERY_ASSIGNMENTS.DELIVERY_DETAIL_ID to WSH_DELIVERY_DETAILS.DELIVERY_DETAIL_ID to obtain line-level content.
  • Join to WSH_EXCEPTIONS on DELIVERY_ASSIGNMENT_ID to report exceptions raised against specific assignments.

Analysts use this table to validate that every delivery detail has a corresponding active assignment (ACTIVE_FLAG), to identify orphaned parent references, and to support delivery consolidation and split audits. Filtering on PROGRAM_ID and REQUEST_ID assists in tracing rows created by specific concurrent requests, which is useful for troubleshooting shipping processes.

Related Objects

  • WSH_NEW_DELIVERIES — referenced twice through DELIVERY_ID and PARENT_DELIVERY_ID; supplies delivery header and hierarchy information.
  • WSH_DELIVERY_DETAILS — referenced through DELIVERY_DETAIL_ID and PARENT_DELIVERY_DETAIL_ID; supplies detail-line and parent-detail context.
  • WSH_DEL_ASSGN_INTERFACE — references DELIVERY_ASSIGNMENT_ID; used in open interface processing for assignment data.
  • WSH_EXCEPTIONS — references DELIVERY_ASSIGNMENT_ID; stores exceptions tied to individual assignments.

These relationships identify the primary integration points for the table and define the join paths most commonly required for shipping execution reporting and interface troubleshooting.