Search Results bm_color

Overview

BSC.BSC_SYS_SERIES_COLORS is a configuration table in the Oracle E-Business Suite BSC schema that stores the display color assigned to individual data series and, separately, to the benchmark representation of those series. It supports the Oracle Balanced Scorecard and related performance-management reporting components, where series are plotted on charts, dashboards, and trend visualizations and must retain consistent color assignments across sessions and user interfaces. The table is defined with FND design data (BSC.BSC_SYS_SERIES_COLORS), confirming it is a registered application object rather than a transient or interface table. Its status is VALID and it resides in the APPS_TS_TX_DATA tablespace, the standard transactional data tablespace in an Oracle EBS 12.1.1 or 12.2.2 installation.

The documented physical schema records three columns and a single unique index, BSC_SYS_SERIES_COLORS_U1, on SERIES_ID in the APPS_TS_TX_IDX tablespace. The primary key is BSC_SYS_SERIES_COLORS_PK on SERIES_ID. From a heuristic Data Vault perspective, the table is classified as standalone, but its narrow, key-plus-attributes shape is consistent with a satellite-style reference or lookup structure keyed by a single series identifier. The classification should be treated as a modeling suggestion only; the operative fact is that the table holds color attributes attached to a series identifier.

Key Information Stored

Only three columns are documented for this object, and each carries a distinct meaning:

• SERIES_ID (NUMBER) — The surrogate primary key and the sole unique-index business-key candidate. It identifies the series whose presentation attributes are being stored and is the column through which dependent fact-like tables, notably BSC_BIS_MEASURES_DATA, join back to this table.
• SERIES_COLOR (NUMBER, length 11) — Stores the color value applied to the series in its normal, non-benchmark rendering. The numeric storage reflects the internal color encoding used by the BSC presentation layer rather than a character-based color name.
• BM_COLOR (NUMBER, length 11) — Stores the color value used when the series is rendered as a benchmark series. The BM_ prefix denotes benchmark and is the exact token referenced by users searching for bm_color.

Because both color columns are numeric with a length of eleven, they accommodate the full range of encoded color values required by the charting engine. The absence of mandatory flags in the documented metadata suggests color assignments are optional per series, with the application supplying defaults at runtime where no row or value is present.

Common Use Cases and Queries

The principal use of this table is to resolve the visual treatment of a series at report or dashboard render time. Reporting queries typically join it to the series or measure data that drives chart output so that each plotted line, bar, or marker receives the correct color for both its standard and benchmark forms.

A basic lookup retrieves both color attributes for a known series:

• SELECT SERIES_ID, SERIES_COLOR, BM_COLOR FROM BSC.BSC_SYS_SERIES_COLORS WHERE SERIES_ID = :series_id;

A broader report joins the color table to dependent measure data to produce a fully resolved series listing:

• SELECT d.SERIES_ID, c.SERIES_COLOR, c.BM_COLOR FROM BSC.BSC_BIS_MEASURES_DATA d, BSC.BSC_SYS_SERIES_COLORS c WHERE d.SERIES_ID = c.SERIES_ID AND d.SERIES_ID = :series_id;

Administrative scenarios include auditing which series have non-default color assignments, verifying that benchmark colors are set wherever benchmark series are displayed, and diagnosing rendering inconsistencies where a series appears with an unexpected color because BM_COLOR was left unset or was overridden by a user-level preference. Migration and cloning exercises also reference this table when validating that presentation configuration survives between environments.

Related Objects

The documented dependency information shows the table references no database objects itself but is referenced by others. The significant relationships are:

• BSC.BSC_BIS_MEASURES_DATA — References this table through SERIES_ID; the primary operational join, linking measure data rows to their series color definitions.
• APPS.BSC_SYS_SERIES_COLORS — The APPS-level synonym or view through which application code and ad hoc queries normally access the table.
• BSC_SYS_SERIES_COLORS_PK — The primary key constraint on SERIES_ID, defining uniqueness for the series identifier.
• BSC_SYS_SERIES_COLORS_U1 — The unique index on SERIES_ID in APPS_TS_TX_IDX, supporting both constraint enforcement and single-series lookups.

Together these objects define the contract through which BSC reporting components obtain consistent series coloring for standard and benchmark presentations.