Search Results css_def_def_attributes

Overview

The table CSS_DEF_DEF_ATTRIBUTES is a data entity within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically belonging to the obsolete CSS (Support) module. Its primary function is to establish and manage associations between Defects or Enhancements and their related attributes. As indicated by its name, it serves as a junction or intersection table, resolving the many-to-many relationship between a defect/enhancement record and its associated attribute definitions. The table's purpose is to allow a single defect or enhancement to be linked to multiple Tracking Groups for query and reporting purposes, as well as to multiple Environment Variables. This design enables flexible categorization and contextual tagging of support issues beyond their core transactional data.

Key Information Stored

The table's structure centers on foreign key relationships that link the core entities. The primary key is DEF_ATTRIBUTE_ID, a unique identifier for each association record. The two critical foreign key columns are DEFECT_ID and ATTRIBUTE_ID. DEFECT_ID references the CSS_DEF_DEFECTS_B table, linking to the specific defect or enhancement record. ATTRIBUTE_ID references the CSS_DEF_ATTRIBUTES_B table, which holds the master definition of the attribute itself—whether it is a Tracking Group or an Environment Variable. The table likely contains additional audit columns (e.g., CREATION_DATE, CREATED_BY) common to EBS tables, though these are not explicitly detailed in the provided metadata. It is crucial to note the ETRM's "Implementation/DBA Data" states this table is "Not implemented in this database," suggesting it may be a legacy or placeholder object in standard deployments.

Common Use Cases and Queries

The primary use case is to retrieve all attributes assigned to a particular defect or to find all defects tagged with a specific attribute for reporting. For instance, a support manager might query for all defects associated with a "Critical_Priority" Tracking Group or all enhancements requiring a specific "Database_Version" environment variable. A typical SQL pattern would involve joining to the related master tables:

• To list attributes for a defect: SELECT ca.ATTRIBUTE_NAME FROM CSS_DEF_ATTRIBUTES_B ca, CSS_DEF_DEF_ATTRIBUTES cda WHERE cda.DEFECT_ID = :defect_id AND cda.ATTRIBUTE_ID = ca.ATTRIBUTE_ID.
• To find defects by attribute: SELECT cd.DEFECT_NUMBER FROM CSS_DEF_DEFECTS_B cd, CSS_DEF_DEF_ATTRIBUTES cda WHERE cda.ATTRIBUTE_ID = :attribute_id AND cda.DEFECT_ID = cd.DEFECT_ID.

Given the module's obsolete status and the note on non-implementation, direct operational use in active customizations or reports is unlikely in a standard EBS instance.

Related Objects

CSS_DEF_DEF_ATTRIBUTES has defined dependencies on two core tables, as per its foreign key constraints. The table CSS_DEF_DEFECTS_B is the primary transactional table for defect and enhancement records. The table CSS_DEF_ATTRIBUTES_B serves as the master definition table for all available Tracking Groups and Environment Variables. The relationship is such that CSS_DEF_DEF_ATTRIBUTES sits between these two entities, enabling the many-to-many linkage. Any data integrity or cascade rules would be governed by the primary key (CSS_DEF_DEF_ATTRIBUTES_PK) and these foreign key relationships. No other referencing tables or public APIs are indicated in the provided metadata.