Results for “to_sequence”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

RG_REPORT_DISPLAY_GROUPS is a table in the RG (Application Report Generator) schema of Oracle E-Business Suite, present in both 12.1.1 and 12.2.2. It stores the definitions of report display groups, which act as named groupings that bind a row axis set and a column axis set into a single reusable layout construct. Within the report generator, a display group determines how rows and columns of a report are organized and rendered, allowing the same underlying axis definitions to be reused across multiple report displays without redundant configuration. The table is owned by the RG schema, is marked VALID, and contains 28 columns in the documented 12.2.2 physical schema.

Under the heuristic Data Vault classification mined from its foreign key structure, RG_REPORT_DISPLAY_GROUPS is modeled as satellite-leaning. It carries descriptive attributes (name, description, sequence bounds) alongside contextual foreign keys to axis sets, and it is itself referenced by the RG_REPORT_DISPLAYS table — placing it in a supporting role relative to the primary display entity rather than at the hub of the model.

Key Information Stored

The table's surrogate primary key is REPORT_DISPLAY_GROUP_ID, enforced by the RG_REPORT_DISPLAY_GROUPS_PK constraint. Two unique indexes document business-key candidates: RG_REPORT_DISPLAY_GROUPS_U1 on REPORT_DISPLAY_GROUP_ID (a redundant unique on the surrogate) and RG_REPORT_DISPLAY_GROUPS_U2 on NAME, which establishes the display group name as the meaningful business identifier within the schema.

• REPORT_DISPLAY_GROUP_ID — Surrogate primary key uniquely identifying each display group definition.
• NAME — Business-key attribute, uniquely constrained, providing the user-facing identifier of the display group.
• DESCRIPTION — Free-text description of the display group's purpose.
• ROW_SET_ID — Foreign key to RG_REPORT_AXIS_SETS, defining the row-axis set used by the group.
• COLUMN_SET_ID — Foreign key to RG_REPORT_AXIS_SETS, defining the column-axis set used by the group.
• FROM_SEQUENCE and TO_SEQUENCE — Sequence boundary values bounding the range of axis elements included in the display group.
• CONTEXT — Descriptive flexfield context column, paired with ATTRIBUTE1 through ATTRIBUTE15 for extensible attribute storage.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard Oracle EBS audit columns tracking who created and last modified the record.

Common Use Cases and Queries

Typical use cases involve resolving a display group by name, resolving the axis sets referenced by a display group, or joining display groups to the report displays that use them. A common pattern resolves a display group and its row and column axis sets:

• Lookup by business key: SELECT * FROM RG.RG_REPORT_DISPLAY_GROUPS WHERE NAME = :group_name;
• Resolve axis sets joined from a display group:

SELECT g.REPORT_DISPLAY_GROUP_ID, g.NAME, r.NAME row_set_name, c.NAME col_set_name
FROM RG.RG_REPORT_DISPLAY_GROUPS g, RG.RG_REPORT_AXIS_SETS r, RG.RG_REPORT_AXIS_SETS c
WHERE g.ROW_SET_ID = r.AXIS_SET_ID AND g.COLUMN_SET_ID = c.AXIS_SET_ID;

• Enumerate displays referencing a display group: join RG_REPORT_DISPLAYS on ROW_GROUP_ID or COLUMN_GROUP_ID equal to REPORT_DISPLAY_GROUP_ID.
• Audit usage: filter on LAST_UPDATE_DATE for change tracking, or query FROM_SEQUENCE/TO_SEQUENCE to verify axis range coverage.

Related Objects

• RG_REPORT_AXIS_SETS — Referenced by RG_REPORT_DISPLAY_GROUPS via ROW_SET_ID and COLUMN_SET_ID; provides row and column axis definitions.
• RG_REPORT_DISPLAYS — References RG_REPORT_DISPLAY_GROUPS via ROW_GROUP_ID and COLUMN_GROUP_ID; links display objects to their row and column groups.
• RG_REPORT_DISPLAY_GROUPS_PK — Primary key constraint on REPORT_DISPLAY_GROUP_ID.
• RG_REPORT_DISPLAY_GROUPS_U1 / _U2 — Unique indexes on REPORT_DISPLAY_GROUP_ID and NAME respectively.
• RG schema DFF context columns — CONTEXT plus ATTRIBUTE1–ATTRIBUTE15 expose the descriptive flexfield extension points.