Results for “row_group_id”

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

Overview

RG_REPORT_DISPLAYS is a table within the RG (Application Report Generator) product schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the assignments of report display groups to report display sets, functioning as the associative structure that binds column groups and row groups into a coherent, ordered display definition for a given report display set. In practical terms, the table determines how a report's data is laid out: which row groupings and column groupings participate in that layout, and in what sequence they appear. The object holds VALID status in the documented ETRM metadata and resides in the RG schema.

Under a heuristic Data Vault classification mined from its foreign key structure, RG_REPORT_DISPLAYS is best modeled as a link. It carries no natural descriptive payload of its own beyond ordering and flagging, but it resolves two or three independent entity references — the display set, the row group, and the column group — into a single association record. Each row therefore represents a relationship instance rather than a standalone business entity.

Key Information Stored

The table comprises 28 documented columns. The most significant are grouped below.

• REPORT_DISPLAY_ID — the surrogate primary key, enforced by RG_REPORT_DISPLAYS_PK and additionally covered by the unique index RG_REPORT_DISPLAYS_U1. It uniquely identifies each display assignment record.
• REPORT_DISPLAY_SET_ID — the foreign key to RG_REPORT_DISPLAY_SETS, identifying which display set the assignment belongs to. This column is a business-key candidate, forming part of the composite unique index RG_REPORT_DISPLAYS_U2 alongside SEQUENCE.
• SEQUENCE — the ordinal position of the display entry within its parent display set. The pairing of REPORT_DISPLAY_SET_ID and SEQUENCE enforces a no-duplicate ordering constraint.
• ROW_GROUP_ID — foreign key to RG_REPORT_DISPLAY_GROUPS, identifying the row grouping applied by this display entry.
• COLUMN_GROUP_ID — foreign key to RG_REPORT_DISPLAY_GROUPS, identifying the column grouping applied by this display entry.
• DISPLAY_FLAG — a control indicator determining whether the assignment is rendered or suppressed during report generation.
• DESCRIPTION — free-text description of the display assignment.
• CONTEXT — the descriptive flexfield context reference for the record.
• CREATION_DATE, CREATED_BY — audit columns recording when and by whom the row was created.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — audit columns recording the most recent modification.
• ATTRIBUTE1 through ATTRIBUTE15 — the standard Oracle EBS descriptive flexfield (DFF) attribute segment columns.

The distinction between the surrogate key (REPORT_DISPLAY_ID) and the business key (REPORT_DISPLAY_SET_ID plus SEQUENCE) is important: the former is an internal identifier, while the latter reflects the ordering semantics meaningful to report generation.

Common Use Cases and Queries

Typical use cases center on inspecting and reproducing report display configuration — for example, auditing which row and column groups are attached to a display set, verifying sequencing, or troubleshooting layout issues in a generated report.

• Listing all display assignments for a given display set, ordered by sequence:

SELECT report_display_id, report_display_set_id, sequence,
       row_group_id, column_group_id, display_flag, description
FROM   rg.rg_report_displays
WHERE  report_display_set_id = :set_id
ORDER  BY sequence;

• Joining to RG_REPORT_DISPLAY_GROUPS twice — once for the row group and once for the column group — to produce a human-readable layout map.
• Filtering on DISPLAY_FLAG to isolate active versus suppressed assignments.
• Reconciling ordering gaps or duplicates using the RG_REPORT_DISPLAYS_U2 business key.

Related Objects

• RG_REPORT_DISPLAY_SETS — parent entity; joined via RG_REPORT_DISPLAYS.REPORT_DISPLAY_SET_ID.
• RG_REPORT_DISPLAY_GROUPS — referenced twice, via RG_REPORT_DISPLAYS.ROW_GROUP_ID and RG_REPORT_DISPLAYS.COLUMN_GROUP_ID.
• RG_REPORT_DISPLAYS_PK / RG_REPORT_DISPLAYS_U1 — primary key and unique index on REPORT_DISPLAY_ID.
• RG_REPORT_DISPLAYS_U2 — composite unique index on REPORT_DISPLAY_SET_ID and SEQUENCE, enforcing ordering integrity.
• RG_REPORT_DISPLAYS_UK — unique constraint supporting the REPORT_DISPLAY_SET_ID business key.

Because the RG module is a legacy report-generation component, direct DML on this table is generally not advisable; configuration is best performed through the Application Report Generator forms, which maintain the referential integrity across display sets and display groups.