Search Results resolution_map_detail_id




Overview
Explore in AI Chat

Overview

The CS_SR_RES_CODE_MAPPING_DETAIL table is a core transactional data object within the Oracle E-Business Suite (EBS) Service (CS) module, specifically for releases 12.1.1 and 12.2.2. It functions as a detail table within a configuration framework designed to automate and standardize the assignment of resolution codes to service requests. Its primary role is to store the specific search criteria that, when matched against a service request, determine the appropriate resolution code to apply. This enables rule-based, consistent resolution tracking and reporting, reducing manual entry and improving data quality in the service management lifecycle.

Key Information Stored

The table stores the association between a parent resolution mapping rule and the discrete criteria used to evaluate service requests. While the full column list is not detailed in the provided metadata, the documented foreign keys and primary key reveal its critical structure. The primary key, RESOLUTION_MAP_DETAIL_ID, uniquely identifies each criterion record. The foreign key column RESOLUTION_MAP_ID links the detail record to its parent rule defined in the CS_SR_RES_CODE_MAPPING table. The other key columns define the searchable attributes: INCIDENT_TYPE_ID links to CS_INCIDENT_TYPES_B to filter by the type of service request, and CATEGORY_ID links to MTL_CATEGORIES_B to filter by the item category of the involved product. The table likely contains additional columns to specify operator logic and possibly other criteria like problem code or status.

Common Use Cases and Queries

The primary use case is the backend evaluation of automated resolution code assignment rules when a service request is created or updated. Administrators configure these rules via the application's user interface, which writes records to this table. A common reporting need is to audit all active resolution mapping criteria. A sample query to list all details with their associated rule and criteria descriptions would be:

  • SELECT d.RESOLUTION_MAP_DETAIL_ID, m.MAP_NAME, it.NAME INCIDENT_TYPE, cat.CONCATENATED_SEGMENTS CATEGORY
  • FROM CS.CS_SR_RES_CODE_MAPPING_DETAIL d,
  • CS.CS_SR_RES_CODE_MAPPING m,
  • CS.CS_INCIDENT_TYPES_B it,
  • INV.MTL_CATEGORIES_B cat
  • WHERE d.RESOLUTION_MAP_ID = m.RESOLUTION_MAP_ID
  • AND d.INCIDENT_TYPE_ID = it.INCIDENT_TYPE_ID(+)
  • AND d.CATEGORY_ID = cat.CATEGORY_ID(+);

Another critical scenario is troubleshooting why a specific resolution code was auto-applied, which involves querying this table for rules matching the SR's attributes.

Related Objects

The table is centrally connected to several key EBS objects via foreign key relationships, as documented in the metadata:

  • CS_SR_RES_CODE_MAPPING: This is the parent header table. The join is on CS_SR_RES_CODE_MAPPING_DETAIL.RESOLUTION_MAP_ID = CS_SR_RES_CODE_MAPPING.RESOLUTION_MAP_ID. It defines the overall rule, including the target resolution code.
  • CS_INCIDENT_TYPES_B: Provides the valid service request types. The join is on CS_SR_RES_CODE_MAPPING_DETAIL.INCIDENT_TYPE_ID = CS_INCIDENT_TYPES_B.INCIDENT_TYPE_ID.
  • MTL_CATEGORIES_B: Provides the valid inventory item categories from the Inventory module. The join is on CS_SR_RES_CODE_MAPPING_DETAIL.CATEGORY_ID = MTL_CATEGORIES_B.CATEGORY_ID.

This table is also likely referenced by standard Oracle Service APIs and user interface forms that manage the resolution code mapping functionality.

  • Table: CS_SR_RES_CODE_MAPPING_DETAIL 12.2.2

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_SR_RES_CODE_MAPPING_DETAIL,  object_name:CS_SR_RES_CODE_MAPPING_DETAIL,  status:VALID,  product: CS - Service ,  description: This is the detail table. This table will contain the resolution code -> search criteria association details. ,  implementation_dba_data: CS.CS_SR_RES_CODE_MAPPING_DETAIL , 

  • Table: CS_SR_RES_CODE_MAPPING_DETAIL 12.1.1

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_SR_RES_CODE_MAPPING_DETAIL,  object_name:CS_SR_RES_CODE_MAPPING_DETAIL,  status:VALID,  product: CS - Service ,  description: This is the detail table. This table will contain the resolution code -> search criteria association details. ,  implementation_dba_data: CS.CS_SR_RES_CODE_MAPPING_DETAIL , 

  • View: CS_SR_RES_CODE_MAPPING_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_SR_RES_CODE_MAPPING_V,  object_name:CS_SR_RES_CODE_MAPPING_V,  status:VALID,  product: CS - Service ,  description: This view lists the mapping of resolution codes to service request types and inventory items. ,  implementation_dba_data: APPS.CS_SR_RES_CODE_MAPPING_V , 

  • View: CS_SR_RES_CODE_MAPPING_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_SR_RES_CODE_MAPPING_V,  object_name:CS_SR_RES_CODE_MAPPING_V,  status:VALID,  product: CS - Service ,  description: This view lists the mapping of resolution codes to service request types and inventory items. ,  implementation_dba_data: APPS.CS_SR_RES_CODE_MAPPING_V ,