Search Results bic_measures

Overview

BIC_MEASURES is a reporting view within the Oracle EBS Customer Intelligence (BIC) module. The BIC product family provides analytical and customer-facing intelligence functionality, and BIC_MEASURES exposes the set of measurable business metrics (measures) that can be evaluated, weighted, and reported against within that framework. The view presents a read-only projection of the underlying ALL-table, meaning it is a secured layer intended for query and reporting rather than for transactional maintenance.

The ETRM metadata notes that this object is associated with the BIC - Customer Intelligence module, which is marked obsolete in the Oracle EBS 12.1.1 / 12.2.2 documentation set. The implementation metadata further states that the view is "Not implemented in this database," indicating that for the referenced environment the object does not physically exist and is documented primarily for reference purposes. The WITH READ ONLY clause in the view text confirms that no INSERT, UPDATE, or DELETE operations are supported through the view.

Underlying Base Objects

The documented view text defines BIC_MEASURES as a SELECT over a single base object:

• BIC_MEASURES_ALL — the source table containing the full, unsecured set of measure definitions.

The view selects a defined column list from BIC_MEASURES_ALL and appends the WITH READ ONLY constraint. The presence of ORG_ID and SECURITY_GROUP_ID columns indicates that BIC_MEASURES_ALL is a multi-organization / multi-tenant style table, and the view is the mechanism through which row-level and organization-level security is applied. No other referenced base objects are documented in the ETRM metadata.

Key Columns

• MEASURE_ID — primary identifier for the measure record.
• MEASURE_CODE — the user-facing code that uniquely labels the measure within the application.
• NAME — descriptive name of the measure.
• ORG_ID — operating unit / organization to which the measure belongs.
• ENABLED_FLAG — indicates whether the measure is active and available for use.
• DESCRIPTION — free-text explanation of the measure.
• WEIGHT — numeric weighting applied when the measure is aggregated or scored.
• TIME_UNIT_CODE — code identifying the time unit (for example, day, week, month, quarter) over which the measure is evaluated or reported. This is the column referenced in the user's search and is central to time-based measure calculations.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — standard EBS audit columns.
• SECURITY_GROUP_ID — identifier used by the security group / multi-tenant access model.

Common Use Cases and Queries

Because BIC_MEASURES is a read-only reporting view, typical usage centers on listing available measures, filtering by organization or enabled status, and inspecting the time granularity assigned to each measure. Note that since the view is documented as not implemented in the current database, queries should be validated against the target environment before deployment.

Example: list enabled measures with their time unit:

• SELECT measure_id, measure_code, name, time_unit_code, weight FROM bic_measures WHERE enabled_flag = 'Y';
• SELECT measure_code, name FROM bic_measures WHERE org_id = :p_org_id AND time_unit_code = :p_time_unit;

These patterns support analytical reports that group measures by organization, ranking measures by weight, or joining measure codes to fact data for Customer Intelligence dashboards. All access remains strictly read-only.