Search Results itm_user_sequence_id




Overview
Explore in AI Chat

Overview

The table WSH_ITM_USER_SETUPS is a core data object within the Oracle E-Business Suite Shipping Execution (WSH) module, specifically supporting integration with partner In-Transit Management (ITM) applications. Its primary role is to store and manage login credentials and configuration settings for external logistics or transportation management systems that interface with Oracle Shipping. The table facilitates flexible registration models, allowing a trading partner company to configure a single login for its entire enterprise, distinct logins for individual operating units or organizations, or even more granular setups. This enables secure and controlled data exchange for shipment visibility and event management across the supply chain.

Key Information Stored

The table's structure is designed to link partner identities with Oracle EBS internal entities. While the full column list is not detailed in the provided metadata, the foreign key relationships highlight its critical components. The primary key, ITM_USER_SEQUENCE_ID, uniquely identifies each login setup record. The APPLICATION_ID column, referencing FND_APPLICATION, likely identifies the specific ITM application partner. The APPLICATION_USER_ID, referencing FND_USER, stores the corresponding username or identifier for the external system. The VENDOR_ID column, referencing WSH_ITM_VENDORS, links the setup to a specific trading partner vendor defined within Oracle. Additional columns, inferred from the description, would store the actual login secrets (e.g., passwords or tokens) and context-level flags (e.g., company, organization) to define the registration's scope.

Common Use Cases and Queries

This table is central to ITM integration workflows. A common operational use case is validating partner system access when an inbound XML transaction is received; the system queries this table to authenticate the source. For administrative purposes, queries are used to audit or manage partner access. A typical reporting query might join to related tables to list all configured logins:

  • SELECT wius.itm_user_sequence_id, fuser.user_name, wiv.vendor_name, fa.application_short_name FROM wsh_itm_user_setups wius, fnd_user fuser, wsh_itm_vendors wiv, fnd_application fa WHERE wius.application_user_id = fuser.user_id AND wius.vendor_id = wiv.vendor_id AND wius.application_id = fa.application_id;

Another common scenario involves troubleshooting integration failures by verifying that the login credentials for a specific vendor and organization are active and correctly configured in this table.

Related Objects

As defined by its foreign keys, WSH_ITM_USER_SETUPS has direct dependencies on several key EBS foundation and shipping tables. The table WSH_ITM_VENDORS (WSH.WSH_ITM_VENDORS) stores master information about the partner vendors themselves. For user and application context, it references the core tables FND_USER (APPL.FND_USER) for the user identity and FND_APPLICATION (APPL.FND_APPLICATION) for the registered ITM application. This table is also likely referenced by various internal APIs and views within the Shipping module that handle the construction and parsing of ITM messages, ensuring that outbound communications use the correct partner-specific credentials and that inbound messages are properly authenticated.

  • Table: WSH_ITM_USER_SETUPS 12.2.2

    owner:WSH,  object_type:TABLE,  fnd_design_data:WSH.WSH_ITM_USER_SETUPS,  object_name:WSH_ITM_USER_SETUPS,  status:VALID,  product: WSH - Shipping Execution ,  description: Stores the login information of different partner ITM Applications. We allow registration at mutiple levels. A company may choose to have single login for entire company, or a separate login for each of its organizations or a separate login ,  implementation_dba_data: WSH.WSH_ITM_USER_SETUPS , 

  • Table: WSH_ITM_USER_SETUPS 12.1.1

    owner:WSH,  object_type:TABLE,  fnd_design_data:WSH.WSH_ITM_USER_SETUPS,  object_name:WSH_ITM_USER_SETUPS,  status:VALID,  product: WSH - Shipping Execution ,  description: Stores the login information of different partner ITM Applications. We allow registration at mutiple levels. A company may choose to have single login for entire company, or a separate login for each of its organizations or a separate login ,  implementation_dba_data: WSH.WSH_ITM_USER_SETUPS , 

  • View: WSH_ITM_USER_SETUPS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:WSH.WSH_ITM_USER_SETUPS_V,  object_name:WSH_ITM_USER_SETUPS_V,  status:VALID,  product: WSH - Shipping Execution ,  implementation_dba_data: APPS.WSH_ITM_USER_SETUPS_V , 

  • View: WSH_ITM_USER_SETUPS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:WSH.WSH_ITM_USER_SETUPS_V,  object_name:WSH_ITM_USER_SETUPS_V,  status:VALID,  product: WSH - Shipping Execution ,  implementation_dba_data: APPS.WSH_ITM_USER_SETUPS_V ,