Results for “wsh_new_del_interface”

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

Overview

WSH_NEW_DEL_INTERFACE is the Deliveries Interface Table within the WSH - Shipping Execution module of Oracle E-Business Suite (documented for 12.1.1 and 12.2.2). It is a staging table that accepts inbound delivery header data from external systems, legacy load processes, transportation management systems, and third-party integrations before that data is validated and promoted into the operational shipping tables. In Oracle Shipping Execution, deliveries represent the physical grouping of order lines into a shippable unit; this interface is the entry point where a delivery header is described — planned dates, ship-to and drop-off locations, carrier and freight information, weights and volumes, ASN state, and address blocks — prior to the ship-confirm lifecycle in the transactional tables.

Because the table is populated from outside the application before being processed, it functions as a staging or landing entity rather than a master record. Mined from the foreign key structure, the heuristic Data Vault classification is satellite-leaning: it carries descriptive attributes and references to hub-like entities (deliveries, parties), functioning as a modeling suggestion of an interface-stage satellite rather than a core hub of master data.

Key Information Stored

The documented physical schema contains 205 columns in the WSH schema. The surrogate primary key is DELIVERY_INTERFACE_ID, enforced by WSH_NEW_DEL_INTERFACE_PK. A second unique index, WSH_NEW_DEL_INTERFACE_U1, also covers DELIVERY_INTERFACE_ID, making it the sole documented business-key candidate for row identification. The most significant columns are:

• DELIVERY_INTERFACE_ID — surrogate primary key for the staging row.
• DELIVERY_ID — foreign key to WSH_NEW_DELIVERIES; links the interface row to the resulting operational delivery.
• NAME, DESCRIPTION, DELIVERY_TYPE — delivery identity and classification.
• STATUS_CODE, ORGANIZATION_ID, SOURCE_HEADER_ID — processing status, inventory organization, and originating header.
• INITIAL_PICKUP_DATE / ULTIMATE_DROPOFF_DATE and corresponding location IDs and codes — planned movement dates and stops.
• CARRIER_ID / CARRIER_CODE, SHIP_METHOD_CODE, FREIGHT_TERMS_CODE, FOB_CODE, SERVICE_LEVEL, MODE_OF_TRANSPORT — transportation and freight terms.
• GROSS_WEIGHT, NET_WEIGHT, WEIGHT_UOM_CODE, VOLUME, VOLUME_UOM_CODE — shipment physical measurements.
• ASN_DATE_SENT, ASN_STATUS_CODE, ASN_SEQ_NUMBER — advance ship notice state.
• INTERFACE_ACTION_CODE, PROCESS_FLAG, PROCESS_MODE, PROCESS_STATUS_FLAG, DELETE_FLAG, LOCK_FLAG — concurrency and interface-processing controls.
• PARTY_ID — foreign key to HZ_PARTIES, plus SHIP_TO_*, INVOICE_TO_*, DELIVER_TO_* address and contact attribute blocks.

Common Use Cases and Queries

The table is used to monitor failed or pending load rows, to reconcile delivered records against their source, and to report on interface health. A typical unresolved-row query is:

SELECT delivery_interface_id, name, status_code,
       interface_action_code, process_status_flag
FROM   wsh.wsh_new_del_interface
WHERE  process_status_flag IS NULL
   OR  process_status_flag = 'N';

To confirm promotion of a staged row into the operational delivery:

SELECT i.delivery_interface_id, i.delivery_id,
       d.delivery_name, d.status_code
FROM   wsh.wsh_new_del_interface i,
       wsh.wsh_new_deliveries   d
WHERE  i.delivery_id = d.delivery_id;

Reporting use cases include exception dashboards on rows where DELETE_FLAG or PROCESS_FLAG indicates failure, carrier and freight-terms analysis prior to confirmation, and reconciliation of incoming ASN statuses by organization.

Related Objects

• WSH_NEW_DELIVERIES — joined on WSH_NEW_DEL_INTERFACE.DELIVERY_ID; the header destination of the interface row.
• HZ_PARTIES — joined on WSH_NEW_DEL_INTERFACE.PARTY_ID; supplies the trading-party identity.
• WSH_DEL_ASSGN_INTERFACE — child table joining on PARENT_DELIVERY_INTERFACE_ID, and separately on DELIVERY_INTERFACE_ID; holds delivery-to-assignment detail lines.
• WSH_DEL_LEGS_INTERFACE — child table joining on DELIVERY_INTERFACE_ID; holds routing leg detail for the delivery.
• WSH_FREIGHT_COSTS_INTERFACE — child table joining on DELIVERY_INTERFACE_ID; holds associated freight cost lines.

Together these interface tables form the inbound staging model that feeds Oracle Shipping Execution's delivery, assignment, leg, and freight processing logic.