Search Results wsh_itm_vendor_parameters




Overview
Explore in AI Chat

Overview

The WSH_ITM_VENDOR_PARAMETERS table is a core data object within the Oracle E-Business Suite Shipping Execution (WSH) module. It functions as a flexible parameter store for third-party logistics (3PL) or carrier integration within the In-Transit Manager (ITM) framework. Its primary role is to store vendor-specific configuration parameters as name-value pairs, enabling the system to communicate with external shipping vendors' web services or APIs. These parameters are essential for customizing the request payload, specifying endpoint handlers, and defining versioning details for outbound transactional data sent to logistics partners, thereby facilitating automated shipping and tracking processes.

Key Information Stored

The table's structure is designed to hold extensible configuration data linked to a specific vendor. The primary and most significant columns include:

  • VENDOR_PARAMETER_ID: The primary key (PK) uniquely identifying each parameter record.
  • VENDOR_ID: The foreign key (FK) linking the parameter to a specific vendor defined in the WSH_ITM_VENDORS table. This establishes the core relationship.
  • PARAMETER_NAME: The name or key of the configuration parameter (e.g., 'Request Version', 'Request Handler', 'Endpoint URL').
  • PARAMETER_VALUE: The corresponding value for the named parameter, which configures the vendor integration.

This name-value pair architecture allows for dynamic and vendor-specific configuration without requiring structural changes to the core application tables.

Common Use Cases and Queries

The primary use case is the retrieval of all configuration parameters for a specific vendor when the system prepares to send a shipping request, such as a shipment confirmation or a tracking status update. A developer or support analyst might query this table to audit or troubleshoot integration settings. A common SQL pattern involves joining to the vendor master table:

SELECT v.vendor_name, p.parameter_name, p.parameter_value
FROM wsh_itm_vendor_parameters p, wsh_itm_vendors v
WHERE p.vendor_id = v.vendor_id
AND v.vendor_name = 'ACME Logistics';

Another typical scenario is identifying which vendors use a specific parameter, aiding in impact analysis for configuration changes. Reporting use cases focus on generating a comprehensive list of all vendor integrations and their active parameters for compliance or documentation purposes.

Related Objects

The table maintains a critical relationship with the primary vendor definition table, as documented in the provided metadata:

  • WSH_ITM_VENDORS: This is the primary parent table. The WSH_ITM_VENDOR_PARAMETERS.VENDOR_ID column is a foreign key referencing the WSH_ITM_VENDORS table. All parameters stored in WSH_ITM_VENDOR_PARAMETERS must be associated with a valid record in this vendors table.

This relationship ensures that vendor-specific parameters are properly scoped and managed within the context of a defined logistics partner. The table may also be referenced by various PL/SQL packages within the WSH_ITM_* namespace that handle the construction and transmission of outbound messages to vendors.