Search Results wsh_del_assgn_interface




Overview
Explore in AI Chat

Overview

The WSH_DEL_ASSGN_INTERFACE table is a core interface table within the Oracle E-Business Suite Shipping Execution (WSH) module for versions 12.1.1 and 12.2.2. It functions as a staging area for data related to the assignment of delivery details to parent deliveries. This table is integral to the inbound interface process, where external systems or internal custom programs populate it with data that the concurrent "Trip/Delivery Interface" program then processes to create or update delivery assignments within the main transactional tables of the Shipping Execution module. Its role is to ensure data integrity and validation before permanent transaction records are created.

Key Information Stored

The table's primary purpose is to hold assignment relationships between delivery details and deliveries during the interface process. Its primary key is DEL_ASSGN_INTERFACE_ID, which uniquely identifies each interface record. The most critical columns are the foreign key references that define these relationships. These include DELIVERY_DETAIL_INTERFACE_ID, linking to the WSH_DEL_DETAILS_INTERFACE table, and PARENT_DELIVERY_INTERFACE_ID, linking to the WSH_NEW_DEL_INTERFACE table for new interface data. Furthermore, it contains PARENT_DELIVERY_DETAIL_ID and PARENT_DELIVERY_ID, which can reference the main transactional tables WSH_DELIVERY_DETAILS and WSH_NEW_DELIVERIES, respectively, for assignments to existing deliveries.

Common Use Cases and Queries

The primary use case is the integration of delivery assignment data from external Warehouse Management Systems (WMS), third-party logistics (3PL) systems, or custom order management extensions. A typical process involves inserting records into this interface table and then submitting the standard "Trip/Delivery Interface" concurrent request. Common diagnostic queries include checking for unprocessed or errored records. For example, to identify pending interface records for a specific delivery detail, one might use:

  • SELECT * FROM WSH.WSH_DEL_ASSGN_INTERFACE WHERE DELIVERY_DETAIL_INTERFACE_ID = <ID> AND PROCESS_STATUS IS NULL;

Reporting often involves joining to the related interface tables to see the full context of what is staged for assignment before processing.

Related Objects

WSH_DEL_ASSGN_INTERFACE has direct dependencies on several key Shipping Execution tables, as defined by its foreign keys. It is a child table to both WSH_NEW_DEL_INTERFACE (for new delivery headers) and WSH_DEL_DETAILS_INTERFACE (for new delivery lines) within the interface schema. Crucially, it also maintains relationships to the main transactional entities: WSH_NEW_DELIVERIES (delivery headers) and WSH_DELIVERY_DETAILS (delivery lines). The table is central to the interface workflow and is primarily accessed via the standard "Trip/Delivery Interface" concurrent program, which validates its data and moves it into the transactional base tables.