Search Results bsc_sys_series_colors

Overview

BSC_SYS_SERIES_COLORS is a configuration table within the Oracle EBS Balanced Scorecard (BSC) module. It stores series color information used to render scorecard charts, graphs, and visual analytics consistently across the application. The object is owned by the BSC schema, is documented as VALID in ETRM, and contains a minimal physical structure of three columns. Its principal role is to map a series identifier to one or more color attributes so that charting components can apply deterministic, reusable color coding to metric series without embedding color literals in application code.

The ETRM metadata classifies the object heuristically as standalone within a Data Vault modeling context. Because the table holds descriptive attributes tied to a single identified series and is not decomposed into hub, link, and satellite artifacts, the metadata contains no explicit hub, link, or satellite designation. As a modeling suggestion, BSC_SYS_SERIES_COLORS is best treated as a reference or lookup entity rather than a transactional fact or an associative link. Its narrow, three-column footprint reinforces this reading: it is a small configuration dimension supplying presentation values.

Key Information Stored

The documented physical schema for release 12.1.1 defines three columns. The table is anchored by the surrogate primary key BSC_SYS_SERIES_COLORS_PK, defined on the SERIES_ID column. A unique index, BSC_SYS_SERIES_COLORS_U1, also covers SERIES_ID, making it the documented business-key candidate. The remaining attributes carry the color payload applied during scorecard rendering.

• SERIES_ID — The primary key column and the sole documented unique key candidate. It identifies each color-bearing series record and is the value referenced by dependent tables.
• SERIES_COLOR — The color assigned to the series itself, used for the primary series plot or line in charts and scorecards.
• BM_COLOR — A second color attribute, associated with the benchmark (BM) aspect of the series, allowing the benchmark reference to be drawn in a distinct color from the series value.

The distinction between the surrogate primary key and the business-key candidate is nominal in this case: SERIES_ID serves both functions, being enforced through BSC_SYS_SERIES_COLORS_PK and repeated in the unique index BSC_SYS_SERIES_COLORS_U1. No other documented column participates in key enforcement.

Common Use Cases and Queries

The most frequent use of this table is join-driven: resolving a series identifier stored on a measure or scorecard record into its presentation colors. Typical query patterns retrieve the color pair for a given series, as in:

• SELECT SERIES_ID, SERIES_COLOR, BM_COLOR FROM BSC.BSC_SYS_SERIES_COLORS WHERE SERIES_ID = :p_series_id;
• Joining to measure data to render a chart: SELECT m.SERIES_ID, c.SERIES_COLOR, c.BM_COLOR FROM BSC.BSC_BIS_MEASURES_DATA m, BSC.BSC_SYS_SERIES_COLORS c WHERE m.SERIES_ID = c.SERIES_ID;
• Maintenance and audit checks to detect duplicate or missing color definitions: SELECT SERIES_ID, COUNT(*) FROM BSC.BSC_SYS_SERIES_COLORS GROUP BY SERIES_ID HAVING COUNT(*) > 1;

Reporting scenarios include dashboard color governance, verifying that every active series has a defined color, and diagnosing rendering inconsistencies where a series falls back to a default color because its SERIES_ID is absent from this table. Because the table is small and read-intensive, it is a low-risk candidate for lookup caching in custom extensions.

Related Objects

The documented relationship data identifies a single foreign-key dependency. BSC_BIS_MEASURES_DATA.SERIES_ID references BSC_SYS_SERIES_COLORS, making the measures data table the primary consumer of the color definitions. This establishes the join path between measure-level data and presentation colors.

• BSC_BIS_MEASURES_DATA — References BSC_SYS_SERIES_COLORS through SERIES_ID; the principal dependent table consuming series color values.
• BSC_SYS_SERIES_COLORS_PK — Primary key constraint on SERIES_ID, enforcing record uniqueness.
• BSC_SYS_SERIES_COLORS_U1 — Unique index on SERIES_ID, the documented business-key candidate.

Beyond these documented objects, the BSC schema typically contains companion configuration tables for scorecards, measures, and charting preferences that share the SERIES_ID convention. Any custom view or concurrent program that renders Balanced Scorecard graphics should resolve colors through this table by joining on SERIES_ID rather than hard-coding palette values, preserving consistency with the delivered application behavior.