Search Results wsh_del_legs_interface




Overview
Explore in AI Chat

Overview

The WSH_DEL_LEGS_INTERFACE table is a core interface table within the Oracle E-Business Suite Shipping Execution (WSH) module, specifically designed for the inbound integration of delivery leg data. In the context of Oracle EBS 12.1.1 and 12.2.2, it serves as the staging area for information pertaining to the transportation segments, or "legs," of a delivery before this data is validated and processed into the base transactional tables by the Shipping Interface program. A delivery leg defines a specific movement of goods between two points—a pick-up stop and a drop-off stop—within a larger trip. This interface-driven architecture is fundamental for integrating data from external Transportation Management Systems (TMS), legacy systems, or other third-party applications into the Oracle Shipping Execution transactional framework.

Key Information Stored

The table's primary purpose is to hold staging records for each leg of a delivery. The key columns, as indicated by its primary and foreign key relationships, are critical for establishing the correct hierarchical and referential integrity during the interface process. The primary identifier is DELIVERY_LEG_INTERFACE_ID. Crucially, the table stores foreign key references to related interface records: DELIVERY_INTERFACE_ID links the leg to a parent delivery in WSH_NEW_DEL_INTERFACE, while PICK_UP_STOP_INTERFACE_ID and DROP_OFF_STOP_INTERFACE_ID link the leg to its origin and destination stops defined in the WSH_TRIP_STOPS_INTERFACE table. The DELIVERY_LEG_ID column provides a link to the base transactional table WSH_DELIVERY_LEGS, typically populated after successful processing to indicate the final created record.

Common Use Cases and Queries

The primary use case is the batch creation or update of delivery legs via the Shipping Interface concurrent program. Data is inserted into this table, often alongside WSH_NEW_DEL_INTERFACE and WSH_TRIP_STOPS_INTERFACE, from a custom feeder program. Common operational queries involve checking the status of interface records. For instance, identifying legs pending processing or troubleshooting errors by joining to the parent delivery interface table to see records where the PROCESS_STATUS flag indicates 'ERROR'. A typical diagnostic query pattern is:

  • SELECT dli.* FROM wsh_del_legs_interface dli, wsh_new_del_interface ndi WHERE dli.delivery_interface_id = ndi.delivery_interface_id AND ndi.process_status = 'ERROR';

Reporting on planned transportation routes before they are processed into the system can also be performed by querying this interface table in conjunction with the trip stop and delivery interface tables.

Related Objects

As defined by its foreign keys, WSH_DEL_LEGS_INTERFACE has tightly coupled relationships with several other key interface and base tables. It is a child of WSH_NEW_DEL_INTERFACE, which holds the header delivery information. It references WSH_TRIP_STOPS_INTERFACE twice—for both the pick-up and drop-off locations. Upon successful processing by the interface program, records are moved to the base transactional table WSH_DELIVERY_LEGS, to which it also maintains a key reference. Therefore, the main related objects are:

  • WSH_NEW_DEL_INTERFACE (Parent Interface Table)
  • WSH_TRIP_STOPS_INTERFACE (Related Interface Table for Stops)
  • WSH_DELIVERY_LEGS (Base Transactional Table)
  • The standard Oracle API, likely WSH_DELIVERY_LEGS_PUB, which provides the supported programmatic method for creating and updating delivery legs, often interacting with or superseding direct interface table usage.