Results for “bic_standard_values_v”
4 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
BIC_STANDARD_VALUES_V is a read-only reporting view within the Oracle EBS Customer Intelligence (BIC) module. Customer Intelligence, historically marketed as Daily Business Intelligence for Customer Intelligence, provides analytical dashboards, KPIs, and dimensional models used by sales, service, and marketing organizations. The _V suffix indicates that the object is a view rather than a base table, and the presence of the WITH READ ONLY clause in its definition confirms that it is exposed strictly for query and reporting purposes.
The view consolidates standard or "benchmark" measure values for a given measure and reporting period, joining each value to its descriptive measure metadata and to the accounting time dimension. Because BIC is flagged as obsolete in the documentation, customers on EBS 12.1.1 and 12.2.2 may still encounter this view in legacy customizations, but it is no longer part of the actively supported product line. The user-supplied search term "measure_description" maps directly to the MEASURE_DESCRIPTION column exposed by this view, which suggests the object was queried to obtain human-readable descriptions alongside stored standard values.
Underlying Base Objects
According to the documented view text, BIC_STANDARD_VALUES_V is defined over three underlying objects:
- BIC_STANDARD_VALUES (S) — stores the measure code, period start date, and standard value itself (
STD_VALUE). - BIC_MEASURES_ALL (M) — provides the descriptive metadata for each measure, including
NAMEandDESCRIPTION. - BIC_DIMV_TIME (T) — supplies the accounting time dimension attributes such as period name, year, quarter, half-year, and their associated start and end dates.
The three objects are joined by matching MEASURE_CODE between the standard values and measures tables, and matching PERIOD_START_DATE to START_DATE between the standard values and time dimension tables.
Key Columns
- MEASURE_CODE / MEASURE_NAME / MEASURE_DESCRIPTION — the identifier, display name, and long description of each measure. These correspond to the "measure_description" search term.
- PERIOD_START_DATE / START_DATE — the period anchor used to align the standard value with the accounting calendar.
- STD_VALUE — the stored standard or benchmark value for the measure.
- ACT_PERIOD_NAME, ACT_YEAR, ACT_PERIOD_NUM, ACT_QUARTER, ACT_HALF_YEAR — accounting period and calendar attributes.
- ACT_PERIOD_START_DATE, ACT_PERIOD_END_DATE, ACT_YEAR_START_DATE, ACT_QUARTER_START_DATE — date boundaries useful for range filtering and time comparisons.
Common Use Cases and Queries
Typical uses include retrieving the description of a measure alongside its standard value, comparing a standard value against actual performance, and building period-over-period benchmark reports.
SELECT measure_code,
measure_description,
act_period_name,
std_value
FROM bic_standard_values_v
WHERE measure_code = :p_measure_code
ORDER BY period_start_date;
Because the metadata notes the view is "not implemented in this database," administrators must first confirm its existence in their instance before relying on it. In many EBS environments the object will be absent or obsolete, and equivalent data may need to be sourced directly from the BIC base tables or a supported replacement view.
-
View: BIC_STANDARD_VALUES_V 12.1.1
Not implemented in this database·Explore BIC module →
-
View: BIC_STANDARD_VALUES_V 12.2.2
Not implemented in this database·Explore BIC module →
-
12.2.2 FND Design Data 12.2.2
-
12.1.1 FND Design Data 12.1.1