Search Results time_level_value




Overview
Explore in AI Chat

Overview

BISBV_ACTUALS is a read-only database view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the BIS (Applications BIS) product family. In ETRM/Applications BIS, "BISBV" designates a Business Intelligence System base view, and this particular view exposes the collected actual (measured) values that feed the Oracle Business Intelligence and Applications BIS reporting and analytics infrastructure. Because it is a reporting-facing object rather than a transactional entry point, it shields consumers from the underlying storage and presents a stable, denormalized projection of actual performance data.

The view is central to fact-style analysis: each row represents a single actual value at a specific intersection of organizational, time, and dimension levels. ETRM and Applications BIS consumers use it to populate dashboards, performance scorecards, and custom extracts without needing to understand the base table's physical layout. The view is defined WITH READ ONLY, meaning it cannot be used for DML — inserts, updates, and deletes against BISBV_ACTUALS are rejected by the database.

Underlying Base Objects

The view is defined directly over a single base table, BIS_ACTUAL_VALUES, aliased within the view text. The ETRM metadata provided lists no additional referenced base objects, indicating a straightforward one-table projection with no joins, unions, or aggregation at the view layer. All filtering, joins to targets, periods, or dimension hierarchies are deferred to the calling query or to higher-level BIS views and reports.

The base table BIS_ACTUAL_VALUES stores the raw actual values and their level assignments. Because BISBV_ACTUALS applies no WHERE clause and no column transformation, it is functionally a column-list alias of the base table — a thin semantic layer that standardizes the interface exposed to reporting tools.

Key Columns

  • ACTUAL_ID — Primary identifier for the actual value record; join key back to the base table and to related BIS objects.
  • TARGET_LEVEL_ID — Identifies the target level definition that governs the granularity of this actual.
  • ORG_LEVEL_VALUE — The organizational level value. This is the column most commonly referenced in searches such as "org_level_value," since it determines the organization against which the actual is recorded (for example, inventory organization, operating unit, or a defined hierarchy level).
  • TIME_LEVEL_VALUE — The period or time-bucket value (for example, a period name or calendar level).
  • DIMENSION1_LEVEL_VALUE through DIMENSION7_LEVEL_VALUE — Up to seven configurable dimension level values, allowing the target level to define arbitrary analytic dimensions such as product, customer, channel, or cost center.
  • ACTUAL_VALUE — The numeric measured value stored at the defined intersection.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard EBS audit columns for lineage and troubleshooting.

Common Use Cases and Queries

Typical usage includes retrieving actual performance for a given organization and period, extracting facts for a data warehouse load, and reconciling BIS dashboards against underlying transactional data. Because ORG_LEVEL_VALUE is a frequently searched column, the most common query pattern filters on it directly.

SELECT actual_id,
       target_level_id,
       org_level_value,
       time_level_value,
       actual_value
FROM   apps.bisbv_actuals
WHERE  org_level_value = :p_org_level_value
AND    time_level_value = :p_time_level_value;

Analysts also aggregate by organization to produce roll-ups:

SELECT org_level_value,
       SUM(actual_value) AS total_actual
FROM   apps.bisbv_actuals
WHERE  time_level_value = :p_period
GROUP  BY org_level_value
ORDER  BY org_level_value;

In all cases, grant-based access and the read-only nature of the view ensure that BISBV_ACTUALS remains a safe, query-only interface for reporting and integration consumers.