Search Results col_set_use_privilege

Overview

RG_REPORT_DISPLAY_SETS_V is a view owned by the APPS schema within the Application Report Generator (RG) product, the module that underpins Oracle EBS financial statement generation (FSG) and related reporting constructs. The ETRM documentation lists the object as VALID and annotates its description as "10SC ONLY," indicating that the view was introduced for a specific release lineage and is not universally present across all Oracle EBS deployments. In Oracle EBS 12.1.1 and 12.2.2, the RG module retained the majority of its original schema objects, and this view remains part of the RG data dictionary layer.

The view presents report display set definitions — the named combinations of a row set and a column set that determine the layout of a financial report. Beyond a simple projection of the base display set table, RG_REPORT_DISPLAY_SETS_V enriches each record with the names of the associated row and column axis sets and computes two data-security privilege flags. This makes the view the primary read interface for report definitions in multi-organization, security-aware reporting environments.

Underlying Base Objects

The view is defined over two base objects in the APPS schema:

• RG_REPORT_DISPLAY_SETS (synonym) — the driving table holding the report display set header, including identity, descriptive, and DFF (descriptor flexfield) columns.
• RG_REPORT_AXIS_SETS (synonym) — joined twice, once for the row set (RS) and once for the column set (CSET), each via an outer join on AXIS_SET_ID.

Two PL/SQL packages are referenced for runtime security evaluation:

• FND_DATA_SECURITY — its CHECK_FUNCTION routine validates the current user's privilege against the GL_DAS_FSG_ROW_SET_U and GL_DAS_FSG_COLUMN_SET_U security functions.
• FND_GLOBAL — supplies the current user context used in the privilege check.

Because the security checks are embedded in the SELECT list, the view returns privilege indicators dynamically at query time.

Key Columns

• ROW_ID — the ROWID of the base display set record; useful for locating the physical row.
• REPORT_DISPLAY_SET_ID — the primary key of the display set.
• NAME / DESCRIPTION — the display set's user-facing name and description.
• ROW_SET_ID / ROW_SET — the row axis set identifier and its resolved name.
• COLUMN_SET_ID / COLUMN_SET — the column axis set identifier and its resolved name.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard Who columns.
• CONTEXT and ATTRIBUTE1–15 — the descriptor flexfield columns.
• ROW_SET_USE_PRIVILEGE / COL_SET_USE_PRIVILEGE — computed flags returning 'Y' (privilege granted or security disabled) or 'N' (privilege denied), evaluated per current user.

Common Use Cases and Queries

Typical scenarios include listing report definitions with resolved axis-set names, and filtering to display sets the current user is authorized to run or modify.

SELECT report_display_set_id, name, row_set, column_set
FROM   apps.rg_report_display_sets_v
WHERE  row_set_use_privilege = 'Y'
AND    col_set_use_privilege = 'Y';

For auditing join coverage, note that the axis-set joins are outer joins; a display set may return NULL row_set or column_set where no matching axis set exists:

SELECT report_display_set_id, name
FROM   apps.rg_report_display_sets_v
WHERE  row_set IS NULL OR column_set IS NULL;

Because the privilege columns rely on FND_DATA_SECURITY and FND_GLOBAL, the view is most reliable when queried from within the EBS application context rather than ad hoc external sessions.