Search Results rg_dss_systems_uk1

Overview

RG_DSS_SYSTEMS is a table owned by the RG schema (Application Report Generator) in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores Financial Analyzer financial data set definitions. Within EBS, the RG product historically supported the Oracle Financial Analyzer/Express-based reporting and multidimensional analysis stack, and RG_DSS_SYSTEMS acts as the master registry of "systems" — analytical data sets that group a set of account segments, a calendar (period set), and optional variable definitions for reporting and modeling purposes. Each row represents a single Financial Analyzer system, identified by a surrogate SYSTEM_ID and a unique business name.

From a modeling perspective, the heuristic Data Vault classification of RG_DSS_SYSTEMS is hub-leaning, with SYSTEM_ID serving as the hub key and NAME as a candidate business key. The table also carries descriptive and control attributes (freeze flag, flexfield context, incremental-data flag), which behave satellite-like, but the dominant structure is a central hub referenced by dependent child tables.

Key Information Stored

The table contains 28 columns, of which the following are the most significant:

• SYSTEM_ID — Surrogate primary key (RG_DSS_SYSTEMS_PK) and also a documented unique index (RG_DSS_SYSTEMS_U1). This is the value propagated to all child tables.
• NAME — Business-key candidate (unique index RG_DSS_SYSTEMS_U2); the user-facing name of the Financial Analyzer system.
• PERIOD_SET_NAME — Foreign key to GL_PERIOD_SETS, defining the calendar/accounting periods the system uses.
• ID_FLEX_CODE and ID_FLEX_NUM — Identify the key flexfield and its structure instance that the system's segment layout is based on.
• FREEZE_FLAG — Controls whether the system definition may be modified.
• SAVE_INCREMENTAL_DATA_FLAG — Determines whether incremental data is retained for the system.
• CONTEXT and ATTRIBUTE1 through ATTRIBUTE15 — The standard EBS descriptive flexfield (DFF) columns, available for customer-specific extensions.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, CREATED_BY — Standard EBS audit columns used for concurrency and change tracking.

Common Use Cases and Queries

Typical uses include listing all defined Financial Analyzer systems, verifying which period set and flexfield structure a system uses, and auditing recent changes for support or migration work.

• Enumerate active systems:

  SELECT system_id, name, period_set_name, freeze_flag
  FROM   rg.rg_dss_systems
  ORDER BY name;

• Resolve the calendar behind a system:

  SELECT s.name, p.period_set_name, p.description
  FROM   rg.rg_dss_systems s, gl_period_sets p
  WHERE  s.period_set_name = p.period_set_name
  AND    s.name = :system_name;

• Audit recently modified systems:

  SELECT system_id, name, last_update_date, last_updated_by
  FROM   rg.rg_dss_systems
  WHERE  last_update_date > SYSDATE - 30;

• Count dependent segment-order and variable definitions per system using the child tables (see below).

Related Objects

• GL_PERIOD_SETS — Referenced by RG_DSS_SYSTEMS.PERIOD_SET_NAME; supplies calendar definitions.
• RG_DSS_SYSTEM_SEG_ORDER — Child table; joins on SYSTEM_ID to define the ordering of segments within the system.
• RG_DSS_SYSTEM_VARIABLES — Child table; joins on SYSTEM_ID to store variable definitions.
• RG_DSS_SYSTEMS_PK — Primary key constraint on SYSTEM_ID.
• RG_DSS_SYSTEMS_UK1 / U1 / U2 — Unique constraints/indexes on SYSTEM_ID and NAME.

Because RG_DSS_SYSTEMS is the hub, most related objects are its segment-order and variable children, plus the GL period-set parent. Reports and data loads should always join through SYSTEM_ID and honor the FREEZE_FLAG and SAVE_INCREMENTAL_DATA_FLAG settings before initiating updates.