Search Results cs_sr_prob_code_mapping




Overview
Explore in AI Chat

Overview

The CS_SR_PROB_CODE_MAPPING table is a core configuration entity within the Oracle E-Business Suite Service (CS) module, specifically for releases 12.1.1 and 12.2.2. It serves as a master mapping repository that governs the valid associations between problem codes, service request (SR) types, and inventory items. Its primary role is to enforce data integrity and streamline the service request creation process by providing a predefined set of problem codes relevant to a specific type of service request and, optionally, a specific product category. This ensures consistency in problem reporting and facilitates accurate categorization and routing of service incidents.

Key Information Stored

The table's central record is identified by a unique PROBLEM_MAP_ID. Each row defines a mapping rule through key foreign key columns. The INCIDENT_TYPE_ID links to CS_INCIDENT_TYPES_B to specify the applicable service request type. The CATEGORY_ID links to MTL_CATEGORIES_B to optionally restrict the mapping to a particular inventory item category. The table itself stores the high-level mapping rule; the specific problem codes (from the CS_INCIDENT_SEVERITIES table) associated with this rule are detailed in the child table CS_SR_PROB_CODE_MAPPING_DETAIL, linked via the PROBLEM_MAP_ID.

Common Use Cases and Queries

A primary use case is the dynamic population of problem code lists in the SR creation UI, filtered by the selected SR type and inventory item. Administrators utilize this table to maintain and audit these business rules. Common reporting needs include listing all configured mappings or identifying valid problem codes for a given context. A typical query to retrieve active mappings with their details would be:

  • SELECT map.problem_map_id, type.name sr_type, cat.concatenated_segments category, sev.name problem_code
  • FROM cs_sr_prob_code_mapping map
  • JOIN cs_incident_types_b type ON type.incident_type_id = map.incident_type_id
  • LEFT JOIN mtl_categories_b_kfv cat ON cat.category_id = map.category_id
  • JOIN cs_sr_prob_code_mapping_detail det ON det.problem_map_id = map.problem_map_id
  • JOIN cs_incident_severities_b sev ON sev.incident_severity_id = det.problem_code_id;

Related Objects

The table is integral to a defined relational structure within the Service schema. Its documented foreign key relationships are as follows:

  • Primary Key: CS_SR_PROB_CODE_MAPPING_PK on PROBLEM_MAP_ID.
  • Parent Tables:
    • CS_INCIDENT_TYPES_B: Joined via CS_SR_PROB_CODE_MAPPING.INCIDENT_TYPE_ID. Provides the Service Request Type.
    • MTL_CATEGORIES_B: Joined via CS_SR_PROB_CODE_MAPPING.CATEGORY_ID. Provides the Inventory Item Category.
  • Child Table:
    • CS_SR_PROB_CODE_MAPPING_DETAIL: References this table via CS_SR_PROB_CODE_MAPPING_DETAIL.PROBLEM_MAP_ID. Stores the individual problem codes for each mapping rule.