Results for “rg_reports_v”
26 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
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:
- APPLICATION_ID, REPORT_ID — the composite identifier of the FSG report; REPORT_ID is used in the security function arguments (TO_CHAR(RP.REPORT_ID)).
- NAME, REPORT_TITLE, DESCRIPTION — the internal name and user-facing title of the report.
- SECURITY_FLAG — when 'Y', row-level FFG/FSG security rules (GL_DAS_FSG_REPORT_V, GL_DAS_FSG_REPORT_U, GL_DAS_FSG_REPORT_M) are evaluated; otherwise privileges default to 'Y'.
- ROW_SET_ID, COLUMN_SET_ID, REPORT_DISPLAY_SET_ID, CONTENT_SET_ID, ROW_ORDER_ID — foreign keys to the axis, display, content, and ordering sets.
- COLUMN_SET, ROW_SET, REPORT_DISPLAY_SET, CONTENT_SET, ROW_ORDER — the resolved NAME values from the joined set objects.
- VIEW_PRIVILEGE, USE_PRIVILEGE, MODIFY_PRIVILEGE — computed DECODE values ('Y'/'N') reflecting the current user's access rights.
- ROUNDING_OPTION, PARAMETER_SET_ID, UNIT_OF_MEASURE_ID, ID_FLEX_CODE, STRUCTURE_ID, SEGMENT_OVERRIDE, OVERRIDE_ALC_LEDGER_CURRENCY, OUTPUT_OPTION — FSG configuration attributes; plus CONTEXT and ATTRIBUTE1–15 descriptive flexfield columns.
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.
-
View: RG_REPORTS_V 12.1.1
APPS.RG_REPORTS_V·↳ FND_DATA_SECURITY·↳ FND_GLOBAL·↳ RG_LOOKUPS·Explore RG module →
-
View: RG_REPORTS_V 12.2.2
APPS.RG_REPORTS_V·↳ FND_DATA_SECURITY·↳ FND_GLOBAL·↳ RG_LOOKUPS·Explore RG module →
-
VIEW: APPS.RG_REPORTS_V 12.1.1
-
VIEW: APPS.RG_REPORTS_V 12.2.2
-
12.2.2 FND Design Data 12.2.2
-
SYNONYM: APPS.RG_ROW_ORDERS 12.1.1
-
12.1.1 FND Design Data 12.1.1
-
SYNONYM: APPS.RG_ROW_ORDERS 12.2.2
-
VIEW: APPS.RG_LOOKUPS 12.1.1
-
12.1.1 DBA Data 12.1.1
-
SYNONYM: APPS.RG_REPORTS 12.1.1
-
12.2.2 DBA Data 12.2.2
-
SYNONYM: APPS.RG_REPORTS 12.2.2
-
VIEW: APPS.RG_LOOKUPS 12.2.2
-
eTRM - RG Tables and Views 12.1.1
-
eTRM - RG Tables and Views 12.2.2
-
eTRM - RG Tables and Views 12.1.1
-
12.2.2 DBA Data 12.2.2
-
eTRM - RG Tables and Views 12.2.2
-
12.1.1 DBA Data 12.1.1