Search Results service_parameter_id

Overview

The WSH_ITM_SERVICE_PARAMETERS table is a core data object within the Oracle E-Business Suite Shipping Execution (WSH) module, specifically for versions 12.1.1 and 12.2.2. It functions as a flexible extension table designed to store supplementary, vendor-specific configuration parameters for shipping services. Its primary role is to support the Integrated Transportation Management (ITM) or carrier integration features by allowing the storage of service attributes as name-value pairs. This structure enables the system to accommodate unique requirements or data points mandated by different transportation vendors (carriers) for their specific services beyond the standard service definition.

Key Information Stored

The table stores parameterized details linked to a vendor service. The most critical columns, as indicated by the provided metadata, are the primary and foreign keys that establish data integrity and relationships. The SERVICE_PARAMETER_ID column serves as the unique primary key identifier for each parameter record. The VENDOR_SERVICE_ID is a foreign key column that links each parameter record to its parent service definition in the WSH_ITM_VENDOR_SERVICES table. While the specific name and value column details are not enumerated in the provided excerpt, the description confirms the table stores parameters as name-value pairs. Typically, such a structure would include columns like PARAMETER_NAME and PARAMETER_VALUE to hold the configurable attribute and its setting, respectively, for a given vendor service.

Common Use Cases and Queries

This table is central to scenarios requiring detailed carrier service configuration. A common use case is during the rate shopping or shipment booking process, where the application retrieves vendor-specific parameters to correctly format API calls or validate shipment data against carrier rules. For reporting and troubleshooting, queries often join this table to its parent to analyze service configurations. A fundamental query pattern is:

• Retrieving all parameters for a specific vendor service: SELECT * FROM WSH.WSH_ITM_SERVICE_PARAMETERS WHERE VENDOR_SERVICE_ID = <id>;
• Joining to the vendor service table for a comprehensive view: SELECT vs.SERVICE_CODE, param.* FROM WSH.WSH_ITM_VENDOR_SERVICES vs, WSH.WSH_ITM_SERVICE_PARAMETERS param WHERE vs.VENDOR_SERVICE_ID = param.VENDOR_SERVICE_ID;

Technical consultants may query this table to verify custom parameter setups or to diagnose issues related to carrier communication.

Related Objects

The table has a direct and critical dependency on the WSH_ITM_VENDOR_SERVICES table, as defined by the documented foreign key relationship. This relationship is fundamental to the data model:

• WSH_ITM_VENDOR_SERVICES: This is the primary parent table. The foreign key column WSH_ITM_SERVICE_PARAMETERS.VENDOR_SERVICE_ID references the primary key in WSH_ITM_VENDOR_SERVICES. This links every parameter set to a specific instance of a vendor service. The integrity of data in WSH_ITM_SERVICE_PARAMETERS is contingent on valid records in this parent table.

While not listed in the provided metadata, this table is likely referenced by various internal Shipping Execution APIs and programs that process carrier integrations, such as those responsible for generating shipping labels, manifests, or rate requests.