Search Results y_axis_title




Overview
Explore in AI Chat

Overview

APPS.BSC_KPI_TREE_NODES_VL is a multilingual (language-resolved) view in the Oracle EBS Balanced Scorecard (BSC) module, owned by the APPS schema and registered against FND Design Data BSC.BSC_KPI_TREE_NODES_VL. Its object type is VIEW, its status is VALID, and its view type is documented as a MultiLingual view — a language-resolved view of the data. The view exposes the definition of KPI tree nodes used to render scorecard strategy maps and simulation diagrams, including layout geometry, formatting, color semantics, and axis labeling. It presents translated, language-specific textual attributes (name and help) joined to the non-translated descriptive attributes stored in the base table.

BSC uses this view to display translated information in whichever languages are installed at a site. Because it resolves the session language, reports, OAF pages, and PL/SQL simulation APIs reading from the view automatically receive node labels and help text in the user's current language without requiring custom language-handling logic.

Underlying Base Objects

The view is defined over two documented base objects:

  • BSC_KPI_TREE_NODES_B — the non-translated ("B" for base) table holding language-independent node attributes such as geometry, format, and indicator references.
  • BSC_KPI_TREE_NODES_TL — the translation ("TL") table holding language-specific columns such as NAME and HELP, keyed by language and source language.

The VL view joins the translated, language-specific rows from BSC_KPI_TREE_NODES_TL with the non-displayed data from BSC_KPI_TREE_NODES_B. From a dependency standpoint, the view is referenced by the simulation APIs BSC_SIMULATION_VIEW_PUB, BSC_SIMULATION_VIEW_PVT (referenced twice in the documented dependency listing), indicating that scorecard simulation rendering logic consumes the resolved node rows directly.

Key Columns

The documented column list, with datatypes and lengths as reported by ETRM, is as follows:

  • INDICATOR (NUMBER) — identifier linking the node to the underlying KPI indicator definition.
  • NODE_ID (NUMBER) — primary identifier of the tree node.
  • NAME (VARCHAR2(75)) — translated display name of the node.
  • HELP (VARCHAR2(240)) — translated help or descriptive text for the node.
  • SIMULATE_FLAG (NUMBER) — indicates whether the node participates in simulation.
  • FORMAT_ID (NUMBER) — reference to the display format configuration.
  • COLOR_FLAG (NUMBER) and COLOR_METHOD (NUMBER) — control whether and how the node is color-coded.
  • NAVIGATES_TO_TREND (NUMBER) — flag indicating the node drills through to a trend view.
  • TOP_POSITION, LEFT_POSITION, WIDTH, HEIGHT (NUMBER) — pixel geometry for rendering the node on the diagram canvas.
  • AUTOSCALE_FLAG (NUMBER) — controls automatic scaling of the associated chart.
  • Y_AXIS_TITLE (VARCHAR2(90)) — the y-axis title for the node's chart; the metadata notes this is a y-axis title with a maximum of 30 characters.

The Y_AXIS_TITLE column is directly relevant to the search term "y_axis_title", as it supplies the caption rendered along the vertical axis of a KPI trend or simulation chart.

Common Use Cases and Queries

Typical usage includes verifying node labels in a specific language, auditing scorecard layout metadata, and extracting chart axis captions for reporting or migration. The documented query text is:

  • SELECT INDICATOR, NODE_ID, NAME, HELP, SIMULATE_FLAG, FORMAT_ID, COLOR_FLAG, COLOR_METHOD, NAVIGATES_TO_TREND, TOP_POSITION, LEFT_POSITION, WIDTH, HEIGHT, AUTOSCALE_FLAG, Y_AXIS_TITLE FROM APPS.BSC_KPI_TREE_NODES_VL;
  • To isolate chart labeling metadata: SELECT NODE_ID, NAME, Y_AXIS_TITLE, AUTOSCALE_FLAG FROM APPS.BSC_KPI_TREE_NODES_VL WHERE Y_AXIS_TITLE IS NOT NULL;
  • To find nodes configured for simulation: SELECT NODE_ID, NAME FROM APPS.BSC_KPI_TREE_NODES_VL WHERE SIMULATE_FLAG = 1;

Because the view resolves language at query time, no additional joins to translation tables are required in consumer code, which simplifies custom reports and integration extracts built against the BSC schema.