Results for “rg_report_exception_flags”

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

Overview

RG_REPORT_EXCEPTION_FLAGS is a table owned by the RG schema within the Oracle E-Business Suite Application Report Generator (RG) module. Its documented purpose is to store the symbols used to indicate exceptions in generated reports — in other words, the flag definitions that determine how exception conditions are visually or textually marked when a report is produced. The table exists across both Oracle EBS 12.1.1 and 12.2.2, with the ETRM 12.2.2 documentation confirming a physical schema of 27 columns and a status of VALID.

From a data-modeling perspective, the heuristic Data Vault classification mined from the foreign-key structure is link. This classification should be treated as a modeling suggestion rather than an authoritative designation: the table sits between the exception definitions in RG_REPORT_EXCEPTIONS and the axis definitions in RG_REPORT_AXES, and it carries its own descriptor column (FLAG). A hybrid reading — a link table that also carries descriptive satellite attributes — is consistent with the observed key structure.

Key Information Stored

The table's primary key is RG_REPORT_EXCEPTION_FLAGS_PK, defined on EXCEPTION_ID in the documented ETRM implementation data. Two unique indexes serve as business-key candidates: RG_REPORT_EXCEPTION_FLAGS_U1 on EXCEPTION_ID and RG_REPORT_EXCEPTION_FLAGS_U2 on the composite (AXIS_SET_ID, AXIS_SEQ). The overlap between RG_REPORT_EXCEPTION_FLAGS_U1 and the primary key indicates that EXCEPTION_ID is both the surrogate identifier used by the PK constraint and a natural uniqueness candidate in this schema.

• EXCEPTION_ID — Primary key column and foreign key to RG_REPORT_EXCEPTIONS; the surrogate identifier for a report exception flag record.
• AXIS_SET_ID — Foreign key to RG_REPORT_AXES identifying the axis set to which the flag applies.
• AXIS_SEQ — Sequence number within the axis set, forming the second component of the U2 unique index.
• FLAG — The symbol or indicator value used to mark exceptions on reports; the core descriptive payload of the row.
• DESCRIPTION — Human-readable description of the exception flag.
• APPLICATION_ID — Identifies the owning application context for the record.
• CONTEXT — Descriptive flexfield context discriminator.
• ATTRIBUTE1 through ATTRIBUTE15 — Descriptive flexfield segment columns reserved for customer-specific extension.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit columns capturing who created and last modified each row.

Common Use Cases and Queries

The most frequent access pattern is resolving the flag symbol associated with a given exception. A typical join retrieves the exception definition together with its flag:

• SELECT f.exception_id, f.flag, f.description FROM rg.rg_report_exception_flags f WHERE f.exception_id = :exception_id;
• SELECT f.exception_id, f.axis_set_id, f.axis_seq, f.flag FROM rg.rg_report_exception_flags f ORDER BY f.axis_set_id, f.axis_seq;
• Joining to RG_REPORT_EXCEPTIONS on EXCEPTION_ID to obtain the full exception definition alongside the flag symbol.
• Joining to RG_REPORT_AXES on AXIS_SET_ID (and AXIS_SEQ) to map flags back to their axis configuration.

Reporting use cases include auditing which exception symbols are configured for a given axis set, validating that every axis sequence has an assigned flag, and extracting flexfield context values (ATTRIBUTE1–15) for site-specific exception handling. Because the table carries standard EBS audit columns, change-tracking queries based on LAST_UPDATE_DATE are also practical.

Related Objects

• RG_REPORT_EXCEPTIONS — Referenced by RG_REPORT_EXCEPTION_FLAGS.EXCEPTION_ID; the parent table holding exception definitions.
• RG_REPORT_AXES — Referenced by RG_REPORT_EXCEPTION_FLAGS.AXIS_SET_ID; provides the axis set and sequence context.
• RG_REPORT_EXCEPTION_FLAGS_PK — Primary key constraint on EXCEPTION_ID.
• RG_REPORT_EXCEPTION_FLAGS_U1 — Unique index on EXCEPTION_ID.
• RG_REPORT_EXCEPTION_FLAGS_U2 — Unique index on (AXIS_SET_ID, AXIS_SEQ).

These objects should be treated as the primary dependency set when analyzing or extending exception flag configuration within the Application Report Generator module.