Search Results navigates_to_trend




Overview
Explore in AI Chat

Overview

BSC_KPI_TREE_NODES_VL is a reporting view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the Balanced Scorecard (BSC) module. It presents a language-resolved, user-facing projection of the KPI tree node definitions that drive the graphical layout of scorecard KPI trees. In EBS 12.1.1 and 12.2.2, the view is registered with STATUS = VALID and is documented in the ETRM repository. Its central purpose is to join the base table holding language-independent node attributes with the translation table holding language-dependent text, applying the session language through USERENV('LANG'). This design follows the standard Oracle multi-language ("_VL") view convention and allows forms, OAF pages, and BI Publisher reports to retrieve node names and help text in the caller's language without embedding translation logic in application code.

Underlying Base Objects

The view is defined over exactly two documented base objects:

The join predicate links the two tables on INDICATOR and NODE_ID, with the additional filter TL.LANGUAGE = USERENV('LANG') restricting the translation row to the current session language. No additional base objects are documented in the ETRM metadata for this view. Functionally, the view acts as a thin, deterministic join layer: it introduces no aggregation or filtering beyond the language restriction, so each node in the tree yields at most one row per session language.

Key Columns

  • INDICATOR — identifier of the KPI/indicator to which the tree node belongs; part of the composite key.
  • NODE_ID — identifier of the individual node within the KPI tree; part of the composite key.
  • NAME — translation-resolved display name of the node (from the TL table).
  • HELP — translation-resolved help text for the node.
  • NAVIGATES_TO_TREND — flag indicating whether activating the node navigates the user to the associated trend chart or trend view. This is the column referenced by searches for "navigates_to_trend".
  • SIMULATE_FLAG — indicates whether the node participates in simulation scenarios.
  • FORMAT_ID — reference to the display format configuration applied to the node.
  • COLOR_FLAG and COLOR_METHOD — control whether and how conditional color coding is applied to the node.
  • TOP_POSITION, LEFT_POSITION, WIDTH, HEIGHT — geometric attributes defining the node's placement and size on the KPI tree canvas.
  • AUTOSCALE_FLAG — derived via NVL(B.AUTOSCALE_FLAG, 0), ensuring a non-null value; indicates whether the node's scale is computed automatically.
  • Y_AXIS_TITLE — translation-resolved title for the Y axis associated with the node.

Common Use Cases and Queries

Typical uses include rendering KPI trees in the Balanced Scorecard UI, exporting tree definitions for analysis, and auditing node configuration such as trend navigation and color rules. Because the view is language-aware, it is the preferred access path over the base tables for any user-facing extraction.

Retrieve all nodes for a given KPI indicator:

  • SELECT indicator, node_id, name, navigates_to_trend, top_position, left_position, width, height FROM apps.bsc_kpi_tree_nodes_vl WHERE indicator = :p_indicator ORDER BY node_id;

Identify nodes configured to navigate to trend charts:

  • SELECT indicator, node_id, name, simulate_flag FROM apps.bsc_kpi_tree_nodes_vl WHERE navigates_to_trend = 'Y';

Review canvas layout and autoscale behavior for a KPI:

  • SELECT node_id, name, top_position, left_position, width, height, autoscale_flag FROM apps.bsc_kpi_tree_nodes_vl WHERE indicator = :p_indicator;

Confirm translation coverage by joining to the base table and inspecting mismatched languages:

  • SELECT b.indicator, b.node_id, tl.language, tl.name FROM apps.bsc_kpi_tree_nodes_b b, apps.bsc_kpi_tree_nodes_tl tl WHERE b.indicator = tl.indicator AND b.node_id = tl.node_id;

Oracle Proprietary, Confidential Information — Legal Notices apply to the underlying definitions.