Search Results css_def_res_times




Overview
Explore in AI Chat

Overview

The CSS_DEF_RES_TIMES table is a reference data object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the now-obsolete CSS (Support) module. Its primary function was to define standardized service level targets for resolving and closing defects and enhancement requests. The table established a matrix of expected resolution times based on key attributes like problem category and severity, enabling structured service level management and performance reporting within the support framework. As indicated by its "Obsolete" status, this table and its associated module are no longer actively developed or implemented in newer database instances, with its functionality likely superseded by other applications like Oracle Service.

Key Information Stored

The table's structure centers on linking problem attributes to target timeframes. The primary key, DEFECT_RES_TIME_ID, uniquely identifies each rule or record in the matrix. The two critical foreign key columns form the core dimensions of the rule set: PROBLEM_CATEGORY_ID, referencing CSS_DEF_PROB_CATEGORIES_B, and SEVERITY_ID, referencing CSS_DEF_SEVERITIES_B. While the specific resolution time columns are not detailed in the provided metadata, based on the table's purpose, it would typically contain numeric columns to store target durations (e.g., in hours or days) for initial response, resolution, and closure. These durations would represent the service level agreement (SLA) targets for combinations of category and severity.

Common Use Cases and Queries

This table was central to operational and analytical processes in the legacy Support module. A common use case was validating or defaulting the expected resolution time on a new service request based on its classified category and severity. For reporting, it enabled analysis of support team performance against defined SLAs. A typical analytical query would join this table with the main defects or service requests table to compare actual resolution times against the targets defined in CSS_DEF_RES_TIMES.

  • Sample Query for SLA Target Lookup:
    SELECT sev.name SEVERITY, cat.name CATEGORY, res.target_resolution_hours
    FROM css_def_res_times res,
        css_def_severities_b sev,
        css_def_prob_categories_b cat
    WHERE res.severity_id = sev.severity_id
    AND res.problem_category_id = cat.problem_category_id
    ORDER BY sev.name, cat.name;

Related Objects

CSS_DEF_RES_TIMES is integrally linked to two other foundational tables in the obsolete Support schema, as defined by its foreign key constraints. The CSS_DEF_PROB_CATEGORIES_B table stores the valid list of problem categories or types. The CSS_DEF_SEVERITIES_B table stores the valid list of severity levels (e.g., Critical, High, Medium). Any main transactional table storing defect or enhancement records (not explicitly named in the metadata but logically presumed, such as a table like CSS_DEFECTS_F) would have likely referenced CSS_DEF_RES_TIMES to determine or store applicable SLA targets for a given record.