Search Results adhoc_prefix

Overview

APPS.RG_REPORT_NAME_V is a reporting view in the Oracle E-Business Suite Financial Statement Generator (FSG) schema. It exposes the header-level definition of FSG reports stored in RG_REPORTS, resolving the various axis sets, content sets, display sets, and row orders that together describe a report's layout. The view is primarily consumed by the FSG report submission and definition user interfaces, where it supplies the list of report names that a user is authorized to run or maintain.

The object is closely associated with the data security function GL_DAS_FSG_REPORT_U (also referenced as the privilege set GL_DAS_FSG_REPORT). When an FSG report is defined with SECURITY_FLAG = 'Y', the view invokes FND_DATA_SECURITY.CHECK_FUNCTION against the report ID and the current user, returning a USE_PRIVILEGE value of Y or N. This is the mechanism by which report-level access control is enforced. Administrators searching for gl_das_fsg_report_u are typically investigating why a given responsibility or user cannot see an FSG report, and this view is the definitive source of that determination.

Underlying Base Objects

The view is defined over the following documented objects:

• RG_REPORTS (synonym, aliased RP) — the driving table holding FSG report definitions, including name, title, security flag, axis set references, rounding options, and flexfield structure.
• 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_CONTENT_SETS (synonym) — outer-joined to supply the content set name.
• RG_ROW_ORDERS (synonym) — outer-joined to supply the row-order name.
• RG_REPORT_DISPLAY_SETS (synonym) — outer-joined to supply the display-set name.
• RG_LOOKUPS (view) — filters out ad hoc reports by matching the lookup type FSG_ADHOC_REPORT_NAME_PREFIX and prefix code ADHOC_PREFIX.
• FND_DATA_SECURITY and FND_GLOBAL (packages) — provide the security check and current user context.

The joins on content set, row order, and display set are outer joins, since these attributes are optional on a report definition.

Key Columns

• APPLICATION_ID, REPORT_ID — primary identifying keys of the FSG report.
• NAME, REPORT_TITLE, DESCRIPTION — the report's internal name, displayed title, and description.
• SECURITY_FLAG — indicates whether row-level security is applied to the report.
• USE_PRIVILEGE — derived value indicating whether the current user holds the GL_DAS_FSG_REPORT_U privilege for the report.
• COLUMN_SET, ROW_SET — the resolved axis set names that define report columns and rows.
• CONTENT_SET, ROW_ORDER, REPORT_DISPLAY_SET — optional layout attribute names.
• ROUNDING_OPTION, OUTPUT_OPTION, MINIMUM_DISPLAY_LEVEL — output formatting controls.
• ID_FLEX_CODE, STRUCTURE_ID, SEGMENT_OVERRIDE — accounting flexfield context for the report.
• OVERRIDE_ALC_LEDGER_CURRENCY, UNIT_OF_MEASURE_ID, PARAMETER_SET_ID — currency and parameter controls.
• EXCEPTIONS_FLAG — hard-coded to 'N' in this view.

Common Use Cases and Queries

Typical uses include auditing report security configuration, listing reports accessible to a user, and diagnosing visibility problems tied to GL_DAS_FSG_REPORT_U.

List all secured FSG reports and whether the current user may use them:

• SELECT report_id, name, report_title, security_flag, use_privilege FROM apps.rg_report_name_v WHERE security_flag = 'Y' ORDER BY name;

Retrieve full layout attributes for a specific report:

• SELECT name, column_set, row_set, content_set, row_order, rounding_option FROM apps.rg_report_name_v WHERE name = 'MY_FSG_REPORT';

Identify reports that lack a content set or display set (possible misconfiguration):

• SELECT name, report_title FROM apps.rg_report_name_v WHERE content_set IS NULL OR report_display_set IS NULL;

Because USE_PRIVILEGE depends on FND_GLOBAL.USER_NAME, results vary by the session's effective user, so the view should be queried in the correct application context when validating access.