Search Results act_period_start_date




Overview
Explore in AI Chat

Overview

The Oracle E-Business Suite object BIC_SUMV_ACTIVATION is a database view belonging to the BIC — Customer Intelligence product family. In the ETRM 12.2.2 documentation this module is explicitly marked Obsolete, and the metadata records that the view is Not implemented in this database. Consequently, BIC_SUMV_ACTIVATION should be regarded as a legacy artifact that survives in the data dictionary of older 12.1.1 and 12.2.2 installations but carries no current functional role.

Where it was deployed, the view presented a flattened, reporting-ready projection of customer activation metrics. Each row represented a single party (customer) measured against a defined accounting or reporting period, with the activation figure already filtered to exclude null values. By exposing pre-derived period attributes — year, period number, quarter, and half-year — the view was designed to let downstream reports, Discoverer workbooks, or ETL routines group and compare activation without recomputing calendar logic. This is directly relevant to a search such as act_quarter, which is the column that classified each activation record into a fiscal or calendar quarter.

Underlying Base Objects

The documented source is a single base object: BIC_PARTY_STATUS_SUMM_V, itself a summary view rather than a physical table. The ETRM metadata lists no referenced base objects for this view, meaning the shipped documentation does not trace the underlying physical tables beneath BIC_PARTY_STATUS_SUMM_V. The defining query is a straightforward projection:

  • The SELECT list draws all period, customer, geographic, and activation columns from BIC_PARTY_STATUS_SUMM_V.
  • The predicate WHERE ACTIVATION IS NOT NULL removes parties that have no activation figure for the period.
  • The clause WITH READ ONLY declares the view non-updatable, confirming its purely analytical purpose.

Because the view is defined over another view, its performance characteristics depend on the summarization logic inside BIC_PARTY_STATUS_SUMM_V. No materialized view or index is documented for BIC_SUMV_ACTIVATION itself.

Key Columns

The column list blends period metadata, activation measure, customer, and location attributes:

Common Use Cases and Queries

Typical usage centered on quarterly activation analysis and customer segmentation. A representative query retrieving quarterly activation by market segment:

  • SELECT act_quarter, market_segment_fk, SUM(value) FROM bic_sumv_activation GROUP BY act_quarter, market_segment_fk ORDER BY act_quarter;
  • SELECT party_id, act_year, act_quarter, value FROM bic_sumv_activation WHERE act_year = 2012 AND country = 'US';
  • SELECT act_half_year, AVG(value) FROM bic_sumv_activation GROUP BY act_half_year;

Given the module's obsolete status and the ETRM notation that the view is not implemented, these patterns apply only to historical environments. On supported 12.1.1 or 12.2.2 instances, equivalent metrics should be sourced from the current Customer Intelligence or party-status reporting objects rather than this view.