Search Results wsh_itm_request_control




Overview
Explore in AI Chat

Overview

The WSH_ITM_REQUEST_CONTROL table is a core interface table within the Oracle E-Business Suite Shipping Execution (WSH) module, specifically for the Inbound Transportation Management (ITM) functionality. It serves as the primary request interface table, acting as a staging and control point for outbound ITM requests sent to external transportation management systems (TMS). The table manages the lifecycle of these requests, tracking their submission and providing a link to subsequent responses and detailed item data. Its role is critical for ensuring reliable communication and data integrity between Oracle EBS and integrated logistics service providers.

Key Information Stored

The table's primary key, REQUEST_CONTROL_ID, uniquely identifies each ITM request batch or transaction. A critical foreign key, APPLICATION_ID, links to FND_APPLICATION, identifying the specific Oracle application from which the request originated. While the provided metadata does not list all columns, typical data stored in such an interface control table includes the request payload or a reference to it, the request creation date and status, the processing phase, and identifiers for the associated shipping documents or delivery lines. This structure allows the system to monitor pending, processed, and errored ITM requests.

Common Use Cases and Queries

A primary use case is troubleshooting the status of ITM integrations. Developers and support personnel frequently query this table to identify requests that have failed to process or are stuck in a pending state. Common reporting needs include listing all requests sent within a specific timeframe or for a particular application. Sample SQL patterns often involve joining to FND_APPLICATION for the application name and to related item tables for details.

  • Checking recent request status: SELECT request_control_id, creation_date, status FROM wsh_itm_request_control WHERE creation_date > SYSDATE -1 ORDER BY creation_date DESC;
  • Identifying requests from a specific module: SELECT rc.* FROM wsh_itm_request_control rc, fnd_application fa WHERE rc.application_id = fa.application_id AND fa.application_short_name = 'WSH';

Related Objects

The WSH_ITM_REQUEST_CONTROL table is central to the ITM interface data model, with defined foreign key relationships to several key tables.

  • FND_APPLICATION: Joined via WSH_ITM_REQUEST_CONTROL.APPLICATION_ID. This relationship provides the name and metadata of the originating EBS application.
  • WSH_ITM_ITEMS: Child table joined via WSH_ITM_ITEMS.REQUEST_CONTROL_ID. This table holds the detailed line-level information (items, quantities) associated with the parent control request.
  • WSH_ITM_RESPONSE_HEADERS: Child table joined via WSH_ITM_RESPONSE_HEADERS.REQUEST_CONTROL_ID. This table stores the response headers and statuses received back from the external TMS for the original request.

These relationships form a chain where a single control record in WSH_ITM_REQUEST_CONTROL governs the flow of request items and tracks the corresponding response.