Search Results color_size

Overview

APPS.BSC_TAB_VIEW_KPI_VL is a language-dependent (MLS) view in Oracle E-Business Suite, owned by the APPS schema. It exposes the translatable attributes of the Balanced Scorecard (BSC) tab view KPI definitions, presenting the subset of KPI display properties that are maintained per installed language. The view is the "_VL" (view-language) companion to the underlying translation table, and it is the object most commonly referenced by concurrent programs, Oracle Forms, OAF pages, and custom reporting when a user-language-specific rendering of dashboard tab KPIs is required.

Functionally, the view resolves the KPI text and graphical presentation settings for a given tab view: positional coordinates, dimensions, font characteristics, and the color-block attributes used to render KPI status indicators on the scorecard tab. The presence of the COLOR_SIZE column — the attribute most associated with the "color_size" search term — confirms that the view carries the sizing metadata that drives the color-coded indicator geometry on BSC dashboards. Because the WHERE clause restricts rows to the session language via USERENV('LANG'), consumers automatically receive only the translation applicable to the current environment, with no additional language filter required in calling SQL.

Underlying Base Objects

The view is defined over a single documented base object: BSC_TAB_VIEW_KPI_TL, the translation (TL) table holding language-specific KPI presentation data for BSC tab views. No additional base tables, synonyms, or joined objects are documented in the ETRM metadata for this definition, and the base object list is recorded as "none documented" at the view level.

The defining text is a straightforward projection with a single predicate:

• SELECT list: TAB_ID, TAB_VIEW_ID, INDICATOR, TEXT_FLAG, LEFT_POSITION, TOP_POSITION, WIDTH, HEIGHT, FONT_SIZE, FONT_STYLE, FONT_COLOR, COLOR_LEFT_POSITION, COLOR_TOP_POSITION, COLOR_WIDTH, COLOR_HEIGHT, COLOR_SIZE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN
• FROM clause: BSC_TAB_VIEW_KPI_TL
• Predicate: WHERE LANGUAGE = USERENV('LANG')

Because the view is a thin projection over the TL table, it inherits the table's multi-language row structure; the LANGUAGE filter is the only mechanism that reduces the result set to the active session language. Standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) are passed through unchanged for audit purposes.

Key Columns

• TAB_ID / TAB_VIEW_ID — Composite keys identifying the tab and the tab view to which the KPI rendering definition belongs.
• INDICATOR — The KPI indicator identifier associated with the rendering definition.
• TEXT_FLAG — Flag governing whether text is displayed for the KPI element.
• LEFT_POSITION, TOP_POSITION, WIDTH, HEIGHT — Coordinate and dimension attributes positioning the KPI element on the tab view canvas.
• FONT_SIZE, FONT_STYLE, FONT_COLOR — Typographic presentation attributes for KPI label text.
• COLOR_LEFT_POSITION, COLOR_TOP_POSITION, COLOR_WIDTH, COLOR_HEIGHT, COLOR_SIZE — Geometry and sizing attributes for the color-coded indicator block; COLOR_SIZE is the sizing dimension that, together with the position and width/height columns, determines the rendered footprint of the status color region.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard audit (WHO) columns.

Common Use Cases and Queries

Typical uses include validating KPI layout metadata during BSC configurations, auditing color-block sizing across tab views, and supporting custom dashboard reports that must respect the session language. A representative query retrieving the layout and color sizing for a specific tab view is:

• SELECT TAB_ID, TAB_VIEW_ID, INDICATOR, FONT_SIZE, FONT_COLOR, COLOR_SIZE, COLOR_WIDTH, COLOR_HEIGHT FROM APPS.BSC_TAB_VIEW_KPI_VL WHERE TAB_ID = :p_tab_id AND TAB_VIEW_ID = :p_tab_view_id;
• SELECT INDICATOR, COLOR_LEFT_POSITION, COLOR_TOP_POSITION, COLOR_WIDTH, COLOR_HEIGHT, COLOR_SIZE FROM APPS.BSC_TAB_VIEW_KPI_VL ORDER BY TAB_VIEW_ID, INDICATOR;
• SELECT TAB_VIEW_ID, COUNT(*) FROM APPS.BSC_TAB_VIEW_KPI_VL GROUP BY TAB_VIEW_ID;

Queries against the view are automatically scoped to the session language and require no explicit LANGUAGE predicate. For rows in a specific language regardless of session, query the base table BSC_TAB_VIEW_KPI_TL directly with an explicit LANGUAGE filter.