Search Results wsh_new_del_interface




Overview
Explore in AI Chat

Overview

The WSH_NEW_DEL_INTERFACE table is a core interface table within the Oracle E-Business Suite Shipping Execution (WSH) module. Its primary role is to serve as a staging area for inbound delivery data before it is processed and validated into the main transactional tables. This table is fundamental to the delivery interface process, enabling the bulk import or programmatic creation of delivery records from external systems, legacy data, or custom front-ends. By utilizing this interface, organizations can automate and streamline the delivery creation workflow, ensuring data integrity before records are committed to the permanent WSH_NEW_DELIVERIES table.

Key Information Stored

The table stores a comprehensive set of attributes required to define a delivery. While the full column list is extensive, the documented metadata highlights several critical fields. The DELIVERY_INTERFACE_ID is the primary key uniquely identifying each interface record. The DELIVERY_ID column is a foreign key linking to the WSH_NEW_DELIVERIES table, populated after successful processing. The PARTY_ID foreign key links to the HZ_PARTIES table, identifying the trading partner (customer or supplier) associated with the delivery. Other typical columns—implied by its function—would include data for delivery name, status, ship-from and ship-to locations, dates, and freight information necessary for shipment planning.

Common Use Cases and Queries

The primary use case is the batch creation of deliveries via the Delivery Interface concurrent program. Data is inserted into WSH_NEW_DEL_INTERFACE, often alongside related records in child interface tables like WSH_DEL_LEGS_INTERFACE. The interface program then validates this data, creates the delivery in WSH_NEW_DELIVERIES, and updates the interface record with the new DELIVERY_ID. Common queries involve monitoring the interface for errors. A typical pattern is to check for unprocessed or error records: SELECT delivery_interface_id, delivery_id, status, error_message FROM wsh_new_del_interface WHERE process_flag = 'ERROR' OR process_flag IS NULL;. Reporting on interface throughput or troubleshooting failed records also relies heavily on querying this table.

Related Objects

  • WSH_NEW_DELIVERIES: The main deliveries transactional table. Records are inserted here from the interface. Joined via WSH_NEW_DEL_INTERFACE.DELIVERY_ID = WSH_NEW_DELIVERIES.DELIVERY_ID.
  • HZ_PARTIES: The Trading Community Architecture registry for parties. Joined via WSH_NEW_DEL_INTERFACE.PARTY_ID = HZ_PARTIES.PARTY_ID to resolve customer or supplier details.
  • WSH_DEL_ASSGN_INTERFACE: A child interface table for delivery assignments. Joined via WSH_DEL_ASSGN_INTERFACE.PARENT_DELIVERY_INTERFACE_ID = WSH_NEW_DEL_INTERFACE.DELIVERY_INTERFACE_ID.
  • WSH_DEL_LEGS_INTERFACE: A child interface table for delivery legs (transportation segments). Joined via WSH_DEL_LEGS_INTERFACE.DELIVERY_INTERFACE_ID = WSH_NEW_DEL_INTERFACE.DELIVERY_INTERFACE_ID.