Results for “css_def_res_times”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

CSS_DEF_RES_TIMES is a reference table within the Oracle E-Business Suite CSS (Support) module, which is classified as obsolete in the documented metadata. Its stated purpose is to serve as a reference table of Defect and Enhancement Resolution and Closure Times. In practical terms, the table stores target or standardised time values that relate a defect or enhancement problem category to a severity level, thereby defining the expected resolution and closure timeframes applied during support and service-request processing.

The metadata explicitly records that this object is Not implemented in this database, meaning that in the environment from which the ETRM documentation was mined, the physical table was absent. This is consistent with the CSS – Support (Obsolete) product classification, and it implies that in Oracle EBS 12.1.1 and 12.2.2 this table is either legacy, superseded, or only present in installations where the older Support/TeleService reference data structures were retained.

From a Data Vault modeling perspective, the heuristic classification mined from the foreign-key structure is link. This suggestion indicates that the table functions primarily as an intersection of two business entities — problem category and severity — rather than as a standalone hub of a single business concept or a descriptive satellite. Its primary key identifies each association row, while the two foreign keys point outward to reference tables.

Key Information Stored

The documented metadata identifies the following columns as significant:

• DEFECT_RES_TIME_ID — the surrogate primary key, defined by the constraint CSS_DEF_RES_TIMES_PK. This is a system-generated identifier that uniquely identifies each resolution/closure time configuration row.
• PROBLEM_CATEGORY_ID — a foreign key referencing CSS_DEF_PROB_CATEGORIES_B. It identifies the defect or enhancement problem category to which the resolution and closure time applies.
• SEVERITY_ID — a foreign key referencing CSS_DEF_SEVERITIES_B. It identifies the severity level for which the resolution and closure time is defined.

Beyond these documented identifiers, the table name and description imply the presence of resolution-time and closure-time values associated with each category-and-severity combination. The metadata does not enumerate additional descriptive columns, and no unique indexes beyond the primary key are documented. Consequently, DEFECT_RES_TIME_ID is the only confirmed surrogate key, while the pairing of PROBLEM_CATEGORY_ID and SEVERITY_ID constitutes the logical business-key candidate that determines the uniqueness of a category/severity time definition.

Common Use Cases and Queries

The principal use case for this table is to derive service-level expectations: given a defect or enhancement categorised under a specific problem category and severity, the table supplies the standard resolution and closure time targets used for reporting, escalation, and compliance measurement against service-level agreements.

Typical query patterns join the table to both reference tables to resolve descriptive names:

• Retrieving all time definitions with category and severity descriptions for a service-level configuration review.
• Filtering by a specific SEVERITY_ID to obtain the resolution time applicable across all problem categories.
• Reporting average or target closure times grouped by problem category for support performance dashboards.

A representative SQL skeleton follows the documented foreign-key paths, joining CSS_DEF_RES_TIMES.PROBLEM_CATEGORY_ID to CSS_DEF_PROB_CATEGORIES_B and CSS_DEF_RES_TIMES.SEVERITY_ID to CSS_DEF_SEVERITIES_B. Because the table is documented as not implemented, any such query should first verify object existence in the target instance.

Related Objects

The documented relationship data identifies the following related objects:

• CSS_DEF_PROB_CATEGORIES_B — referenced through CSS_DEF_RES_TIMES.PROBLEM_CATEGORY_ID; provides the problem category definition.
• CSS_DEF_SEVERITIES_B — referenced through CSS_DEF_RES_TIMES.SEVERITY_ID; provides the severity definition.
• CSS_DEF_RES_TIMES_PK — the primary key constraint enforcing uniqueness on DEFECT_RES_TIME_ID.

Additional dependent objects such as views or APIs are not documented in the supplied metadata, and none should be assumed. The two foreign-table references constitute the complete documented relationship set for this obsolete CSS reference object.