Search Results css_def_prob_types_b




Overview
Explore in AI Chat

Overview

The CSS_DEF_PROB_TYPES_B table is a core data definition table within the now-obsolete CSS (Support) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It serves as the base table for storing master definitions of problem types, which are used to categorize and standardize different kinds of support issues, defects, or service requests logged within the system. As a base table, it holds the fundamental transactional data, with corresponding TL (translated) tables typically storing language-specific descriptions. Its primary role is to provide a controlled, referential list of valid problem types that can be associated with support cases, defect records, and audit history, ensuring data integrity and consistency across the support management processes. The provided metadata explicitly notes this table is "Not implemented in this database," indicating it may be a legacy structure from an earlier version or a planned feature that was never fully deployed in the referenced EBS instances.

Key Information Stored

While the full column list is not detailed in the provided excerpt, the structure and foreign key relationships imply several critical attributes. The primary key is the PROBLEM_TYPE_ID, a unique identifier for each problem type record. A crucial foreign key column is PROBLEM_CATEGORY_ID, which links each problem type to a parent category defined in the CSS_DEF_PROB_CATEGORIES_B table, establishing a hierarchical classification system. Other likely columns include internal codes (e.g., PROBLEM_TYPE_CODE), names (NAME), descriptions (DESCRIPTION), and control columns for tracking data creation and modification (e.g., CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY). Status flags to indicate whether a type is active or inactive for selection are also common in such setup tables.

Common Use Cases and Queries

Given its status as a definition table, primary use cases involve setup, administration, and reporting reference. Administrators would use this table to create, update, or deactivate the list of available problem types during application configuration. Common reporting queries would join this table to transactional tables to analyze case volumes or defect trends by problem type. A typical SQL pattern to retrieve all active problem types within a specific category would resemble:

  • SELECT pt.PROBLEM_TYPE_ID, pt.NAME, pc.NAME AS CATEGORY_NAME FROM CSS_DEF_PROB_TYPES_B pt, CSS_DEF_PROB_CATEGORIES_B pc WHERE pt.PROBLEM_CATEGORY_ID = pc.PROBLEM_CATEGORY_ID AND pt.ENABLED_FLAG = 'Y' ORDER BY pc.NAME, pt.NAME;

Another frequent query involves listing all defects associated with a particular problem type for root cause analysis:

Related Objects

The CSS_DEF_PROB_TYPES_B table is central to the obsolete Support module's data model, as evidenced by its multiple foreign key relationships. Key related objects include:

  • CSS_DEF_PROB_CATEGORIES_B: The parent table, defining the category to which each problem type belongs.
  • CSS_DEF_DEFECTS_B: The main defects table, which references the problem type to classify the defect.
  • CSS_DEF_AUDIT_HISTORY_B: Stores audit trails where changes to problem type assignments may be recorded.
  • CSS_DEF_PROB_TYPE_PHASES: Likely defines the workflow phases or statuses applicable to a specific problem type.
  • CSS_DEF_TEMPL_MATRIX: Possibly maps problem types to specific templates or notification matrices used in the support process.