Search Results rg_dss_dimensions_u3

Overview

RG.RG_DSS_DIMENSIONS is a dimension-definition table within the Oracle E-Business Suite 12.1.1 / 12.2.2 environment, owned by the RG schema. It stores the metadata that describes the analytical dimensions used by the Oracle Financial Analyzer / Decision Support System (DSS) integration layer within Oracle EBS. Each row defines a single dimension — its display name, its internal object name, the prefixes applied to its members, its labeling behavior, and its relationship to an Oracle key flexfield where applicable. The table effectively acts as a master catalog that downstream DSS structures (segments, hierarchies, and variable dimensions) reference when assembling multidimensional analytical models.

From a Data Vault modeling perspective, this object is classified as hub-leaning. The heuristic classification derives from its key structure and foreign-key topology: RG_DSS_DIMENSIONS serves as the parent of several dependent tables, with the DIMENSION_ID column acting as the stable business key referenced by child relationships. In a formal Data Vault design, this pattern maps naturally to a hub, with the descriptive attributes (labels, prefixes, flexfield references) potentially satellite-material.

Key Information Stored

The table contains 36 columns. The most significant are:

• DIMENSION_ID (NUMBER(15)) — Surrogate dimension-defining column and the primary key (RG_DSS_DIMENSIONS_PK). Also the leading column of unique index RG_DSS_DIMENSIONS_U1.
• NAME (VARCHAR2(60)) — Human-readable dimension name; business-key candidate via RG_DSS_DIMENSIONS_U2.
• OBJECT_NAME (VARCHAR2(16)) — Unique internal identifier used by Financial Analyzer; business-key candidate via RG_DSS_DIMENSIONS_U3.
• OBJECT_PREFIX and VALUE_PREFIX — Prefixes applied to the dimension object and its member values.
• ROW_LABEL, COLUMN_LABEL, SELECTOR_LABEL — Control whether Value, Description, or Both are displayed in each layout position.
• LEVEL_CODE and DIMENSION_TYPE — Classify the dimension as Summary/Detail and as Primitive, Single Segment, Multiple Segments, or Time.
• ID_FLEX_CODE and ID_FLEX_NUM — Bind the dimension to a specific Oracle key flexfield structure.
• DESCRIPTION, CONTEXT, and ATTRIBUTE1–15 — Descriptive Flexfield support and free-form metadata.
• ZD_EDITION_NAME — Editioning column present in all three unique indexes, enabling Online Patching in 12.2.2.
• Standard Who columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) for auditability.

Common Use Cases and Queries

Typical use cases include listing all defined dimensions, resolving a dimension by flexfield binding, and joining child structures. For example, to enumerate dimension definitions:

• SELECT dimension_id, name, object_name, dimension_type, level_code FROM rg.rg_dss_dimensions ORDER BY name;
• To locate the flexfield-backed dimensions: SELECT name, id_flex_code, id_flex_num FROM rg.rg_dss_dimensions WHERE id_flex_code IS NOT NULL;
• To inspect the segments belonging to a dimension: SELECT s.* FROM rg.rg_dss_dim_segments s JOIN rg.rg_dss_dimensions d ON s.dimension_id = d.dimension_id;

Reporting scenarios commonly involve reconciling how many hierarchies or variable dimensions attach to each dimension, or validating that the OBJECT_NAME uniqueness constraint was respected before loading into Financial Analyzer. All access should occur through approved Oracle Applications programs, as the object is flagged Oracle Internal Use Only.

Related Objects

The following objects reference RG_DSS_DIMENSIONS through the DIMENSION_ID foreign key:

• RG.RG_DSS_DIM_SEGMENTS — Segments belonging to each dimension (DIMENSION_ID → RG_DSS_DIMENSIONS.DIMENSION_ID).
• RG.RG_DSS_HIERARCHIES — Hierarchical rollup structures for each dimension (DIMENSION_ID → RG_DSS_DIMENSIONS.DIMENSION_ID).
• RG.RG_DSS_VAR_DIMENSIONS — Variable dimension definitions linked to the same key (DIMENSION_ID → RG_DSS_DIMENSIONS.DIMENSION_ID).

Additional related objects include the FND key flexfield definition tables referenced by ID_FLEX_CODE / ID_FLEX_NUM, and standard FND Descriptive Flexfield context tables associated with CONTEXT and ATTRIBUTE columns.