Search Results dimension1_level_name

Overview

APPS.BIS_TARGET_LEVELS_V is an Oracle E-Business Suite internal view owned by the APPS schema and identified by FND Design Data as BIS.BIS_TARGET_LEVELS_V. It is classified as a view of View Type "Internal" and is currently VALID in both Oracle EBS 12.1.1 and 12.2.2 environments. The view exposes the Target Level definitions used by the Oracle Balanced Scorecard (BIS) product family, presenting the dimensionality — organizational, time, and up to seven custom dimensions — against which a given indicator's targets are collected and evaluated. Each row associates an indicator with the specific level identifiers and human-readable level names that define the granularity of its target data. In practical reporting and integration terms, the view functions as a denormalized read-only surface: it joins the identifier columns to their descriptive name columns so that downstream consumers (Discoverer workbooks, OBIEE repositories, custom concurrent programs, or PL/SQL packages) do not need to resolve level names themselves. Because the view is documented as Oracle Internal Use Only, access is supported only through standard Oracle Applications programs; direct custom queries are permitted technically but are not covered by Oracle Support.

Underlying Base Objects

The ETRM 12.2.2 metadata records no referenced base objects for this view ("Referenced base objects: none documented"). The view source is therefore not resolvable from the supplied metadata alone. Based on the column set — which carries both the numeric level IDs (ORG_LEVEL_ID, TIME_LEVEL_ID, DIMENSION1_LEVEL_ID through DIMENSION7_LEVEL_ID) and the corresponding VARCHAR2(30) level names (ORG_LEVEL_NAME, TIME_LEVEL_NAME, DIMENSION1_LEVEL_NAME through DIMENSION7_LEVEL_NAME) alongside WHO columns — the view is defined over the BIS target-level base table (BIS_TARGET_LEVELS) with outer joins to the BIS dimension/level definition tables (such as BIS_LEVELS and BIS_DIMENSIONS) that supply the level names, and to BIS_INDICATORS for INDICATOR_NAME and SHORT_NAME. This composite structure explains why the view is flagged Internal and why only APPS-owned programs should depend on its current column layout.

Key Columns

• TARGET_LEVEL_ID — Primary key of the target level definition; the value that ties a set of dimension/level selections to a target record.
• INDICATOR_ID, INDICATOR_NAME, SHORT_NAME — Identifier and descriptive attributes of the indicator whose targets the level governs.
• ORG_LEVEL_ID / ORG_LEVEL_NAME — Identifier and name of the organizational level at which targets are captured.
• TIME_LEVEL_ID / TIME_LEVEL_NAME — Identifier and name of the time level (for example, month, quarter, year). This is the pairing most directly relevant to a search on "time_level_name"; the column returns the VARCHAR2(30) display name of the time dimension level.
• DIMENSION1_LEVEL_ID … DIMENSION7_LEVEL_ID and DIMENSION1_LEVEL_NAME … DIMENSION7_LEVEL_NAME — Identifier/name pairs for up to seven user-defined dimensions, allowing the view to describe fully multi-dimensional target granularity.
• WF_PROCESS, DEFAULT_ROLE_ID, DEFAULT_ROLE, SYSTEM_FLAG — Workflow process association, default role assignment, and a system-defined indicator flag.
• NAME and DESCRIPTION — User-facing name (VARCHAR2(80)) and description (VARCHAR2(240)) of the target level definition.
• ROW_ID — ROWID pseudo-column, and the standard WHO columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) for audit tracking.

Common Use Cases and Queries

Typical uses include validating that indicator targets are aligned to the intended time and organizational granularity, driving Discoverer or OBIEE target-versus-actual comparisons, and feeding custom extracts into a data warehouse. A representative query listing indicators with their time-level names is:

SELECT indicator_name, time_level_name, org_level_name
FROM   apps.bis_target_levels_v
WHERE  time_level_name IS NOT NULL
ORDER BY indicator_name;

To find all indicators collected at a specific time level:

SELECT indicator_id, indicator_name, short_name
FROM   apps.bis_target_levels_v
WHERE  time_level_name = :p_time_level
AND    system_flag = 'N';

Because the object is internal, any custom dependency should be reviewed before patching or upgrade, as the underlying joins and column list may change without notice between 12.1.1 and 12.2.2.