Search Results rg_reports_v




Overview
Explore in AI Chat

Overview

RG_REPORTS_V is a security-enabled view owned by the APPS schema in Oracle E-Business Suite, belonging to the RG (Application Report Generator) product. In EBS 12.1.1 and 12.2.2 it serves as the primary presentation layer for Financial Statement Generator (FSG) report definitions, exposing the contents of RG_REPORTS together with denormalized descriptive names for the row set, column set, content set, display set, and row order that each report references. Its distinguishing characteristic is that it does not simply project base table columns; it applies Oracle function security through FND_DATA_SECURITY.CHECK_FUNCTION to derive per-user privilege flags at query time.

Underlying Base Objects

The view is defined over the RG_REPORTS synonym (the FSG report definitions table) joined to several configuration objects: RG_REPORT_AXIS_SETS (aliased twice, for the column set where AXIS_SET_TYPE = 'C' and the row set where AXIS_SET_TYPE = 'R'), RG_REPORT_DISPLAY_SETS, RG_REPORT_CONTENT_SETS, and RG_ROW_ORDERS (outer-joined via ROW_ORDER_ID). RG_LOOKUPS is also referenced in the documented FROM clause. Two packages are invoked: FND_GLOBAL supplies the current user name, and FND_DATA_SECURITY performs the privilege checks. Because the joins on column set, row set, display set, and content set are inner joins, a report whose dependent sets are missing will not appear in the view.

Key Columns

Beyond the ROWID-based ROW_ID and standard WHO audit columns, the view exposes:

Common Use Cases and Queries

Administrators and integrators query this view to inventory FSG reports and to audit security. A typical listing selects the report identity and its component set names:

SELECT report_id, name, report_title, row_set, column_set, content_set, report_display_set, rounding_option
FROM apps.rg_reports_v
WHERE security_flag = 'Y';

To identify reports the current user may view but not modify:

SELECT name, view_privilege, use_privilege, modify_privilege
FROM apps.rg_reports_v
WHERE view_privilege = 'Y' AND modify_privilege = 'N';

Because privilege flags are evaluated against FND_GLOBAL.USER_NAME, results are session-dependent and must not be cached across sessions. The view also supports reporting on reports that omit a row order, since that join is outer. When building custom concurrent programs or diagnostic reports, reference RG_REPORTS_V rather than RG_REPORTS directly to inherit standard FSG security and the convenience of pre-resolved set names.