Search Results wsh_itm_vendors




Overview
Explore in AI Chat

Overview

The WSH_ITM_VENDORS table is a core reference table within the Oracle E-Business Suite Shipping Execution (WSH) module. It functions as the master repository for registering and managing partner Integrated Transportation Management (ITM) applications. ITM refers to the framework for integrating external transportation and logistics service providers, such as carriers or freight forwarders, directly into the EBS shipping workflow. This table is essential for enabling automated rate shopping, shipment booking, tracking, and label generation by defining the universe of available external logistics partners that the system can interact with.

Key Information Stored

While the provided ETRM excerpt does not list specific columns, the primary key is documented as VENDOR_ID. Based on its function and standard Oracle EBS design patterns, this table typically stores key identifiers for each logistics partner. Common columns in such a reference table would include a unique VENDOR_ID, the VENDOR_NAME, and codes or identifiers used by the partner's external system. It may also contain configuration flags to indicate the vendor's active status, the types of services supported (e.g., LTL, Parcel), and integration method details. The VENDOR_ID serves as the critical foreign key link to all associated configuration and transaction data stored in related ITM tables.

Common Use Cases and Queries

This table is primarily accessed for setup, configuration, and operational reporting of transportation partners. Common administrative tasks include querying all configured vendors or checking the status of a specific partner. A typical query would retrieve a list of all active ITM vendors: SELECT vendor_id, vendor_name FROM wsh_itm_vendors WHERE enabled_flag = 'Y' ORDER BY vendor_name;. For troubleshooting integration issues, support personnel often join this table to related setup tables to verify that a vendor's parameters and services are correctly defined. The table is also central to any custom report analyzing carrier usage or performance across shipments, requiring joins to delivery and trip tables via the related ITM transaction structures.

Related Objects

The WSH_ITM_VENDORS table sits at the top of a hierarchy of ITM configuration tables, as evidenced by its foreign key relationships. Its primary key (VENDOR_ID) is referenced by the following tables, which store more granular setup and transactional data for each vendor:

  • WSH_ITM_USER_SETUPS: Links vendors to specific EBS user accounts and their preferences.
  • WSH_ITM_VENDOR_PARAMETERS: Stores configuration parameters required for communicating with the vendor's application (e.g., URLs, authentication keys).
  • WSH_ITM_VENDOR_SERVICES: Defines the specific transportation services (like "Next Day Air") offered by the vendor.
  • WSH_ITM_RESPONSE_HEADERS: Logs high-level responses received from the vendor's system for requests like rating or booking.
  • WSH_ITM_RESPONSE_RULES: Contains rules for parsing and interpreting the structured data within vendor responses.
These relationships underscore that WSH_ITM_VENDORS is the master record, and all subsequent vendor-specific configuration is dependent on an entry existing here.