Search Results wsh_del_details_interface




Overview
Explore in AI Chat

Overview

The WSH_DEL_DETAILS_INTERFACE table is a core interface table within the Oracle E-Business Suite Shipping Execution (WSH) module. It functions as the primary staging area for importing and processing delivery line-level information from external systems or legacy applications into the Oracle EBS shipping engine. Its role is critical for data integration, enabling the population of the main transaction table, WSH_DELIVERY_DETAILS, through standard interface programs. This table is essential for automating the creation and update of delivery details, ensuring data integrity and streamlining the inbound logistics flow in both EBS 12.1.1 and 12.2.2.

Key Information Stored

The table stores transactional data required to build delivery lines. As indicated by its primary and foreign keys, the most critical columns include DELIVERY_DETAIL_INTERFACE_ID, the unique identifier for each interface record. The DELIVERY_DETAIL_ID column links the interface record to an existing delivery detail in the WSH_DELIVERY_DETAILS table for updates. The PARTY_ID column, referencing HZ_PARTIES, stores the trading partner identifier. Other significant columns typically include SOURCE_CODE and SOURCE_LINE_ID to identify the originating order line, REQUESTED_QUANTITY, SHIP_FROM and SHIP_TO location details, and various PROCESS_FLAG and STATUS columns to control the interface program's execution and error handling.

Common Use Cases and Queries

The primary use case is the batch import of delivery lines via the "Delivery Interface" concurrent program. A common operational query checks for records pending processing or in error to facilitate troubleshooting.

  • Identifying Pending Interface Lines: SELECT * FROM WSH_DEL_DETAILS_INTERFACE WHERE PROCESS_FLAG = 'P' AND STATUS IS NULL;
  • Investigating Failed Records: SELECT DELIVERY_DETAIL_INTERFACE_ID, STATUS, ERROR_MESSAGE FROM WSH_DEL_DETAILS_INTERFACE WHERE PROCESS_FLAG = 'E';
  • Linking to Source Data: SELECT i.*, d.DELIVERY_DETAIL_ID FROM WSH_DEL_DETAILS_INTERFACE i LEFT JOIN WSH_DELIVERY_DETAILS d ON i.DELIVERY_DETAIL_ID = d.DELIVERY_DETAIL_ID WHERE i.SOURCE_LINE_ID = <line_id>;

Related Objects

As per the provided metadata, WSH_DEL_DETAILS_INTERFACE has direct relationships with several key objects. The primary transaction table, WSH_DELIVERY_DETAILS, is the target for processed interface records. The HZ_PARTIES table provides validated trading partner data via the PARTY_ID foreign key. Furthermore, the WSH_DEL_ASSGN_INTERFACE table references it, indicating that interface records for delivery assignments are dependent on successful detail interface records. This object is also central to the public Oracle Shipping API, particularly the process-oriented programs that validate and transfer data from the interface to the base tables.