Search Results period_date




Overview
Explore in AI Chat

Overview

CSS_DEF_PROD_SUMMARY_V is a reporting view within the Oracle E-Business Suite CSS (Support) product family, which carries the designation "Support (Obsolete)" in the ETRM metadata for releases 12.1.1 and 12.2.2. The view presents a normalized, row-per-metric summary of product defect data, exposing key support performance indicators such as new counts, open counts, average age, and days to resolution across defined measurement periods. Its principal role is to feed summary dashboards and extract queries in which each individual defect metric must appear as a distinct, self-describing row rather than as a separate column. This unpivoted shape simplifies trend reporting, since downstream consumers can filter or group by COUNT_TYPE without referencing metric-specific column names.

Underlying Base Objects

The documented definition shows that CSS_DEF_PROD_SUMMARY_V is a UNION ALL view whose four constituent branches each select from the same base table, CSS_DEF_IR_PROD_SUMMARY. No other base objects are documented. Each branch projects the shared dimensions DATA_TYPE, DATA_VALUE, PERIOD_TYPE, and PERIOD_DATE, then maps one metric pair from the base table into the generic COUNT_VALUE and PERCENT_CHANGE columns of the view. The literal tag assigned to COUNT_TYPE distinguishes the rows: 'NEW' (from NEW_COUNT and NEW_PERCENT_CHANGE), 'OPEN' (from OPEN_COUNT and OPEN_PERCENT_CHANGE), 'AVERAGE_AGE' (from AVERAGE_AGE and AVG_AGE_PERCENT_CHANGE), and 'DAYS_TO_RESOLUTION' (from DAYS_TO_RESOLUTION and DAYS_TO_RES_PERCENT_CHANGE). Because it is a pure projection view, it inherits all row-level security and filtering behavior applied to the base table.

Key Columns

  • DATA_TYPE — Classifies the product/defect data dimension represented by the row.
  • DATA_VALUE — The specific value within that dimension, used in conjunction with DATA_TYPE to identify the reported entity.
  • COUNT_TYPE — Literal discriminator identifying the metric: NEW, OPEN, AVERAGE_AGE, or DAYS_TO_RESOLUTION.
  • PERIOD_TYPE — The granularity of the reporting period (for example, weekly, monthly, or quarterly).
  • PERIOD_DATE — The date anchoring the reporting period.
  • COUNT_VALUE — The metric quantity, sourced from the corresponding count, age, or resolution column in the base table.
  • PERCENT_CHANGE — The period-over-period percentage change for that metric.

Common Use Cases and Queries

The view supports trend analysis of defect inflow and backlog, aging studies, and resolution velocity. A frequently used pattern selects a single metric across a time series, as shown below:

  • New-defect trend: SELECT PERIOD_DATE, DATA_VALUE, COUNT_VALUE, PERCENT_CHANGE FROM CSS_DEF_PROD_SUMMARY_V WHERE COUNT_TYPE = 'NEW' AND PERIOD_TYPE = 'MONTH' ORDER BY PERIOD_DATE;
  • Backlog comparison: pivot COUNT_VALUE by COUNT_TYPE for OPEN and NEW on the same PERIOD_DATE to compare inflow against outstanding volume.
  • Aging and resolution reporting: filter COUNT_TYPE IN ('AVERAGE_AGE','DAYS_TO_RESOLUTION') to monitor service-level performance.
  • Dimension-specific drilldown: add predicates on DATA_TYPE and DATA_VALUE to isolate a product or category.

Because the view is marked obsolete and "not implemented in this database" on supported releases, reviews should confirm availability before use and prefer current support-analytics objects where installed. Where present, its consistent column semantics make it a convenient source for summary extracts into external reporting tools.