Search Results css_def_templ_matrix




Overview
Explore in AI Chat

Overview

The CSS_DEF_TEMPL_MATRIX table is a core data structure within the now-obsolete CSS (Support) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. Its primary function is to manage the dynamic assignment of service request or problem resolution templates based on specific criteria. The table operates as a mapping matrix, defining associations between predefined templates and various attributes of a reported issue, namely Problem Category, Problem Type, and Item. This enables the system to automatically suggest or apply the most appropriate template for a new service request, standardizing data capture and improving support efficiency based on the nature of the problem.

Key Information Stored

The table's structure is designed to store flexible mapping rules. Its key columns include a unique identifier (TEMPLATE_MATRIX_ID) for each mapping rule and the foreign key column TEMPLATE_ID, which points to the specific template in CSS_DEF_TEMPLATES_B. The mapping criteria are stored in three optional foreign key columns: PROBLEM_CATEGORY_ID, PROBLEM_TYPE_ID, and an ITEM column (likely referencing an inventory item). As per the documentation, a valid mapping rule must specify at least one of these three criteria, allowing for granular mappings (e.g., a template for a specific Problem Type on a specific Item) or broader ones (e.g., a default template for an entire Problem Category).

Common Use Cases and Queries

The primary use case is the runtime lookup of a service template when a user creates a new service request. The application would query this matrix using the entered or derived values for category, type, and item to find the best-matched template. A typical query pattern would involve joining to the related descriptive tables. For reporting, administrators might query the matrix to audit or manage template coverage. A sample SQL to retrieve all active mappings with descriptions would be:

Related Objects

CSS_DEF_TEMPL_MATRIX is centrally linked to three key master data tables via foreign key constraints, forming the backbone of the template mapping functionality. The documented relationships are:

  • CSS_DEF_TEMPLATES_B: Joined via CSS_DEF_TEMPL_MATRIX.TEMPLATE_ID = CSS_DEF_TEMPLATES_B.TEMPLATE_ID. This provides the actual template definition referenced by the mapping.
  • CSS_DEF_PROB_CATEGORIES_B: Joined via CSS_DEF_TEMPL_MATRIX.PROBLEM_CATEGORY_ID = CSS_DEF_PROB_CATEGORIES_B.PROBLEM_CATEGORY_ID. This links the mapping to a high-level problem classification.
  • CSS_DEF_PROB_TYPES_B: Joined via CSS_DEF_TEMPL_MATRIX.PROBLEM_TYPE_ID = CSS_DEF_PROB_TYPES_B.PROBLEM_TYPE_ID. This links the mapping to a more specific problem type, often within a category.