Search Results gl_das_fsg_report_m

Overview

APPS.RG_REPORTS_V is a reporting security and metadata view in the Oracle E-Business Suite General Ledger (GL) schema, exposed through the APPS account. It presents the contents of the RG_REPORTS base entity — the repository of Financial Statement Generator (FSG) report definitions — while simultaneously computing row-level privilege information for the current session user. Because FSG reports are definable objects subject to function-based data security, the view bridges raw report metadata with an inline evaluation of the requesting user's authorization.

The view is significant in the context of the search term "gl_das_fsg_report" because its security predicate calls the data security function against the object name GL_DAS_FSG_REPORT, using distinct function names GL_DAS_FSG_REPORT_V (view privilege), GL_DAS_FSG_REPORT_U (use privilege), and GL_DAS_FSG_REPORT_M (modify privilege). These are the same security functions evaluated by the Data Access Set (DAS) model for FSG report objects, meaning RG_REPORTS_V is effectively the security-enforced access path to FSG report definitions. Any query against this view returns only rows the session user is permitted to see, and each row is annotated with the privileges that user holds.

Underlying Base Objects

The view is defined over the following documented objects:

• RG_REPORTS (synonym) — the primary driving table (aliased RP), supplying the report definition columns and the SECURITY_FLAG that governs whether the privilege checks are evaluated.
• RG_REPORT_AXIS_SETS (synonym, aliased CSET and RS) — joined twice to resolve the column set (AXIS_SET_TYPE = 'C') and row set (AXIS_SET_TYPE = 'R').
• RG_REPORT_DISPLAY_SETS (synonym, aliased RPD) — supplies the display set name.
• RG_REPORT_CONTENT_SETS (synonym, aliased COS) — outer-joined to resolve the content set name.
• RG_ROW_ORDERS (synonym, aliased ROD) — outer-joined to resolve the row order name.
• RG_LOOKUPS (view) — referenced in the join clause.
• FND_DATA_SECURITY (package) — invoked as FND_DATA_SECURITY.CHECK_FUNCTION at runtime to evaluate the three FSG privileges.
• FND_GLOBAL (package) — supplies USER_NAME for the security evaluation scope.

The view therefore combines a star-like join of report configuration tables with a runtime function call, making it a security-aware projection rather than a simple denormalization.

Key Columns

• REPORT_ID, APPLICATION_ID, NAME, REPORT_TITLE — identity and descriptive attributes of the FSG report.
• SECURITY_FLAG — when 'Y', the privilege DECODEs are evaluated; otherwise privileges default to 'Y'.
• VIEW_PRIVILEGE, USE_PRIVILEGE, MODIFY_PRIVILEGE — computed 'Y'/'N' flags indicating whether the current user may view, run, or modify the report, derived from the corresponding GL_DAS_FSG_REPORT_* functions.
• COLUMN_SET, ROW_SET, REPORT_DISPLAY_SET, CONTENT_SET, ROW_ORDER — resolved names of the report's axis, display, content, and ordering components.
• ROW_SET_ID, COLUMN_SET_ID, REPORT_DISPLAY_SET_ID, CONTENT_SET_ID, ROW_ORDER_ID, PARAMETER_SET_ID — foreign keys to those component definitions.
• ROUNDING_OPTION, UNIT_OF_MEASURE_ID, ID_FLEX_CODE, STRUCTURE_ID, SEGMENT_OVERRIDE — formatting and accounting flexfield configuration.
• OVERRIDE_ALC_LEDGER_CURRENCY — controls currency translation override behavior.
• OUTPUT_OPTION — governs report output generation.
• CONTEXT and ATTRIBUTE1–ATTRIBUTE15 — descriptive flexfield columns for extensible attributes.

Common Use Cases and Queries

The view is used by FSG report administration, security auditing, and integrations that must respect DAS restrictions on report definitions. Typical queries filter on the computed privileges:

• List reports a user is permitted to run: SELECT report_id, name, report_title FROM apps.rg_reports_v WHERE use_privilege = 'Y';
• Report components associated with a report: SELECT name, row_set, column_set, content_set, row_order FROM apps.rg_reports_v WHERE report_id = :p_report_id;
• Audit security configuration: SELECT name, security_flag, view_privilege, use_privilege, modify_privilege FROM apps.rg_reports_v ORDER BY name;
• Locate reports by flexfield structure: SELECT report_id, name FROM apps.rg_reports_v WHERE id_flex_code = 'GL#' AND structure_id = :p_structure_id;

Because privilege columns invoke FND_DATA_SECURITY.CHECK_FUNCTION per row, performance-sensitive queries should restrict the result set and avoid unnecessary evaluation of the privilege DECODEs where possible.