Search Results css_def_prob_categories_b




Overview
Explore in AI Chat

Overview

The CSS_DEF_PROB_CATEGORIES_B table is a base data definition table within the Oracle E-Business Suite (EBS) Support module, specifically designated as obsolete. Its primary role is to serve as the master repository for defining problem categories. These categories function as a high-level classification tier within the support problem management hierarchy, grouping related problem types. The table's designation as "obsolete" indicates that its associated functionality is deprecated in the referenced EBS versions (12.1.1 and 12.2.2), and it is not actively implemented in the standard database schema, as confirmed by the provided metadata. Its historical purpose was to provide a structural framework for organizing support issues and linking them to associated workflows and resolution metrics.

Key Information Stored

While the full column list is not detailed in the provided metadata, the primary and foreign key relationships define the core data structure. The central column is PROBLEM_CATEGORY_ID, which serves as the unique primary key identifier for each problem category record. The table also contains a WORKFLOW column, which establishes a foreign key relationship to the WF_ITEM_TYPES table. This linkage was designed to associate a specific workflow process with a problem category, automating the support handling process. Other columns would typically include descriptive fields such as a name, code, and active status flag, though these are inferred from standard EBS design patterns rather than the explicit documentation provided.

Common Use Cases and Queries

Given the table's obsolete status and non-implementation, active operational or reporting use cases are non-existent in a standard EBS environment. Its use would be confined to historical data analysis or migration scenarios for customers upgrading from very old implementations where the data was populated. A typical query to retrieve all defined categories, if data were present, would follow this pattern:

  • SELECT PROBLEM_CATEGORY_ID, NAME, WORKFLOW FROM CSS_DEF_PROB_CATEGORIES_B WHERE ENABLED_FLAG = 'Y';

Joins to related definition tables would be used to analyze the complete problem management setup, for example, listing all problem types within a category:

  • SELECT C.NAME AS CATEGORY, T.NAME AS PROBLEM_TYPE FROM CSS_DEF_PROB_CATEGORIES_B C, CSS_DEF_PROB_TYPES_B T WHERE C.PROBLEM_CATEGORY_ID = T.PROBLEM_CATEGORY_ID;

Related Objects

The metadata specifies several foreign key relationships, detailing this table's position in the obsolete data model. The CSS_DEF_PROB_CATEGORIES_B table is a parent to multiple child tables and references one workflow object.

  • Referenced Parent Table: WF_ITEM_TYPES, joined via CSS_DEF_PROB_CATEGORIES_B.WORKFLOW column.
  • Child Tables (Foreign Key points to PROBLEM_CATEGORY_ID):
    • CSS_DEF_PROB_TYPES_B: Stores problem types classified under these categories.
    • CSS_DEF_RES_TIMES: Likely stored resolution time targets or service level agreements (SLAs) defined at the problem category level.
    • CSS_DEF_TEMPL_MATRIX: Possibly defined templates or notification matrices associated with categories.