Search Results wsh_itm_response_lines




Overview
Explore in AI Chat

Overview

The WSH_ITM_RESPONSE_LINES table is a core data object within the Oracle E-Business Suite Shipping Execution (WSH) module, specifically supporting the International Trade Management (ITM) functionality. It operates within the context of compliance screening, where business entities, such as customers or suppliers, and items are checked against denied party lists. This table stores the detailed, line-level results of such screening requests. For every screening request processed, one or more records in this table are generated to capture the specific outcome (e.g., passed, denied, or pending) for each individual party and item combination that was screened. It serves as the child table to the WSH_ITM_RESPONSE_HEADERS, which stores the general metadata for the overall screening response.

Key Information Stored

The table's primary purpose is to log the granular results of a compliance check. Its key columns, as indicated by its foreign key relationships, link it to the specific entities screened and the parent response. The primary identifier is the RESPONSE_LINE_ID. The RESPONSE_HEADER_ID column links the line to its parent response header. The ITEM_ID and PARTY_ID columns are foreign keys that precisely identify which inventory item and which trading partner (customer, supplier, etc.) were evaluated in this specific line of the response. While the provided metadata does not list all columns, typical data in such a table would include the screening status (e.g., 'PASSED', 'DENIED', 'ERROR'), a reason code, the date of the response, and potentially the specific denied list rule that triggered a match.

Common Use Cases and Queries

The primary use case is auditing and reporting on compliance screening history. Organizations require this data to demonstrate due diligence and to investigate any denied transactions. A common query involves joining to the related header and entity tables to produce a comprehensive audit report. For example, to find all denied screening results for a specific customer party, a query would join WSH_ITM_RESPONSE_LINES to WSH_ITM_RESPONSE_HEADERS for request details and to WSH_ITM_PARTIES for party information, filtering on the status column. Technical consultants often query this table to debug integration issues with external screening services or to analyze patterns in screening outcomes. The data is critical for workflows where a 'DENIED' status would halt an order or shipment process within the Order Management and Shipping Execution modules.

Related Objects

The table is centrally connected to other core ITM entities via documented foreign key constraints. Its primary relationships are:

  • Parent Table: WSH_ITM_RESPONSE_HEADERS, joined via WSH_ITM_RESPONSE_LINES.RESPONSE_HEADER_ID.
  • Reference Tables:
    • WSH_ITM_ITEMS, joined via WSH_ITM_RESPONSE_LINES.ITEM_ID.
    • WSH_ITM_PARTIES, joined via WSH_ITM_RESPONSE_LINES.PARTY_ID.
  • Child Table: WSH_ITM_DENIED_PARTIES, which references WSH_ITM_RESPONSE_LINES.RESPONSE_LINE_ID. This suggests a more detailed breakdown of denial information may be stored separately.
These relationships form the essential data model for tracking the lifecycle of a compliance screening request from initiation through to the detailed line-level results.