Search Results cs_sr_type_cat_mappings_pk

Overview

The CS_SR_TYPE_CAT_MAPPINGS table is a core reference table within the Oracle E-Business Suite Service (CS) module, specifically for releases 12.1.1 and 12.2.2. It functions as a junction or mapping table that defines the permissible associations between Service Request Types and Service Request Type Categories. This mapping is critical for enforcing business rules and data integrity during the creation and classification of service requests (incidents). The table's role is to establish a many-to-many relationship between the master definitions of types and categories, enabling a flexible setup where a single service request type can belong to multiple logical categories, and a category can contain multiple types.

Key Information Stored

The table's structure is minimal and focused on storing the relationship keys. The two primary columns constitute the table's composite primary key. INCIDENT_TYPE_ID stores the unique identifier for a Service Request Type, as defined in the CS_INCIDENT_TYPES_B table. SR_TYPE_CATEGORY_ID stores the unique identifier for a Service Request Type Category, as defined in the CS_SR_TYPE_CATEGORIES_B table. Together, each unique pair in this table represents one valid mapping. There are no descriptive columns in this table; all descriptive information is retrieved via joins to the referenced parent tables.

Common Use Cases and Queries

A primary use case is validating user input when creating or updating a service request, ensuring the selected type and category combination is authorized by the application setup. For reporting and administrative purposes, common queries involve listing all established mappings to audit configuration. A typical SQL pattern to retrieve a readable list of mappings would join to the descriptive tables:

• SELECT it.name TYPE_NAME, cat.name CATEGORY_NAME
• FROM cs_sr_type_cat_mappings map,
• cs_incident_types_b it,
• cs_sr_type_categories_b cat
• WHERE map.incident_type_id = it.incident_type_id
• AND map.sr_type_category_id = cat.sr_type_category_id;

Another critical use case is driving LOVs (Lists of Values) in the application interface, where selecting a category filters the available service request types to only those mapped to it.

Related Objects

This table sits at the center of a key relationship between two fundamental setup entities. It has documented foreign key dependencies on the following tables:

• CS_INCIDENT_TYPES_B: The mapping table references this table via the column CS_SR_TYPE_CAT_MAPPINGS.INCIDENT_TYPE_ID. This table holds the master definition of all service request types.
• CS_SR_TYPE_CATEGORIES_B: The mapping table references this table via the column CS_SR_TYPE_CAT_MAPPINGS.SR_TYPE_CATEGORY_ID. This table holds the master definition of all type categories used for grouping and classifying service request types.

The table's primary key, CS_SR_TYPE_CAT_MAPPINGS_PK, is defined on the combination of INCIDENT_TYPE_ID and SR_TYPE_CATEGORY_ID, enforcing the uniqueness of each mapping relationship.