Search Results life_cycle_code




Overview
Explore in AI Chat

Overview

CSS_DEF_IR_DEFECTS_V is a reporting view historically shipped with the Oracle E-Business Suite Customer Support (CSS) module, whose defect-tracking functionality is now obsolete. The view presents a consolidated, read-oriented projection of defect records and is intended for informational queries, defect status reporting, and lightweight integration scenarios where downstream tools require a stable, denormalized column surface rather than direct access to the normalized base table. In Oracle EBS 12.1.1 and 12.2.2 the object is not implemented in the delivered database; ETRM documentation explicitly records "Not implemented in this database" for the Implementation/DBA Data section. Consequently, the view typically appears only in upgraded or legacy environments where the older CSS defect schema survived migration, or in custom installations that retained deprecated support objects. Its practical role is a compatibility layer: it exposes the defect header attributes and costing attributes that reporting consumers expect, while hiding the underlying storage details of the base table.

Underlying Base Objects

The documented definition is a straight projection over a single base table, CSS_DEF_DEFECTS_B, as indicated by the "FROM CSS_DEF_DEFECTS_B" clause at the end of the view text. No other referenced base objects are documented in the ETRM metadata; the "Referenced base objects" field lists "none documented," and the owner is not recorded. Because the view performs no joins or unions, it inherits the row grain of the base table, where one row represents one defect. The "_B" suffix on the base table follows the standard EBS convention for the base (non-translated) portion of a table that may be paired with a "_TL" translation table; the view itself does not expose translated columns. The presence of OBJECT_VERSION_NUMBER and the WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) confirms that the view is built on an entity that participates in EBS concurrency control and audit tracking.

Key Columns

Common Use Cases and Queries

Typical usage centers on defect cost and status reporting. A representative query retrieving open defects with cost estimates follows:

  • SELECT defect_number, status_id, severity_id, estimated_cost, estimated_cost_uom, actual_cost FROM css_def_ir_defects_v WHERE open_flag = 'Y' AND deleted_flag = 'N';
  • SELECT category_type, COUNT(*), SUM(estimated_cost) FROM css_def_ir_defects_v GROUP BY category_type;
  • SELECT defect_number, filed_date, resolved_date, (resolved_date - filed_date) days_to_resolve FROM css_def_ir_defects_v WHERE resolved_flag = 'Y';

Because the object is obsolete and generally unimplemented in 12.1.1 and 12.2.2, any integration depending on it should be validated against the target environment before deployment, and migration toward the supported defect-tracking tables is advisable.