Search Results css_def_defects_all_v

Overview

CSS_DEF_DEFECTS_ALL_V is a denormalized reporting and integration view within the Oracle E-Business Suite CSS (Customer Support/Support) module. Its documented description is simply "Defect information," and in the Oracle ETRM (E-Business Suite Technical Reference Manual) metadata for 12.1.1 and 12.2.2 the object is flagged as belonging to "CSS - Support (obsolete)" and as "Not implemented in this database." The name suffix _ALL_V follows standard EBS naming conventions: it signals a view rather than a physical table, and the _ALL component often implies the query is intended to expose records across operating units or organizations, though the view text exposes ORG_ID directly rather than relying on a Multi-Org secured synonym.

The view presents defect (bug) records maintained by Oracle Support/Quality workflows. Each row represents a single defect identified by DEFECT_ID and DEFECT_NUMBER, enriched with descriptive columns for problem categorization, status, severity, priority, product and component identification, and lifecycle information. Because it consolidates many lookups into a single denormalized projection, it is suitable for ad-hoc reporting, extract/load routines, and integrations that need defect data without joining numerous base tables.

Underlying Base Objects

The ETRM metadata specifies no documented referenced base objects for this view. The view text, however, selects exclusively from a schema-qualified source aliased as DEV (for example, DEV.DEFECT_ID, DEV.OBJECT_VERSION_NUMBER), which in practice corresponds to the underlying defect entity table (often CSS_DEF_DEFECTS) joined through views or synonyms that resolve the *_ID/*_NAME lookup pairs. Several columns carry inline comments marking them "OBSOLETED" as of particular releases: ORG_ID, REASON_ID, REASON_NAME, TESTCASE, TIER_CODE, TIER_MEANING, TEST_TYPE, TEST_TYPE_MEANING, TEST_NAME, PUBLISH-related fields at 11.5.4+, and STATUS_REASON_ID, STATUS_REASON_NAME, KEYWORDS, COMMITMENT_CODE, COMMITMENT_MEANING, DESC_STATUS_REASON at 11.5.3.

The "Not implemented in this database" note means the object is not present in the reference environment catalogued by ETRM; it does not imply the view is invalid in a production CSS installation where the Support module is licensed and configured.

Key Columns

• DEFECT_ID / DEFECT_NUMBER / OBJECT_VERSION_NUMBER — primary key, user-facing defect number, and optimistic locking version.
• ORG_ID / TERRITORY_ID / TERRITORY_NAME — organizational and territory context (ORG_ID marked obsoleted 11.5.4+).
• PROBLEM_CATEGORY_ID/NAME, PROBLEM_TYPE_ID/NAME, PHASE_ID/NAME — classification hierarchy for the defect.
• STATUS_ID/NAME, OPEN_FLAG, OPEN_MEANING — current status and whether the defect remains open.
• SEVERITY_ID/NAME, PRIORITY_ID/NAME, FREQUENCY_CODE/MEANING — impact and urgency indicators.
• PRODUCT_*, FIRST_FOUND_IN_*, COMPONENT_*, SUB_COMP_* — inventory item, description, concatenated segments, and revision of the product, first-found, component, and sub-component items.
• LIFE_CYCLE_CODE/MEANING, PUBLISH_EXT_FLAG/MEANING, SUMMARY — lifecycle stage, external publishing flag, and defect summary text.

Common Use Cases and Queries

Typical uses include open-defect dashboards, severity distribution reports, product quality extracts, and integration feeds into external defect trackers. Because obsolete columns may still exist physically, filter on current columns to avoid confusion.

SELECT defect_number, summary, status_name, severity_name, priority_name
FROM   css_def_defects_all_v
WHERE  open_flag = 'Y'
ORDER  BY severity_id, priority_id;

SELECT problem_category_name, COUNT(*) defect_count
FROM   css_def_defects_all_v
WHERE  life_cycle_code = 'ACTIVE'
GROUP  BY problem_category_name
ORDER  BY defect_count DESC;

When using the view, verify that the OBSOLETED columns (ORG_ID, REASON_ID, TIER_CODE, TEST_TYPE, KEYWORDS, COMMITMENT_CODE) are not referenced in new code, and confirm module availability, since the CSS Support module is itself documented as obsolete in modern releases.