Search Results gl_das_fsg_report_set_u

Overview

APPS.RG_REPORT_SET_NAME_V is a security-aware view over the RG_REPORT_SETS synonym in Oracle EBS Release 12.1.1 and 12.2.2. Its purpose is to expose the descriptive attributes of Financial Statement Generator (FSG) report sets while appending a computed privilege indicator so that consumers — concurrent programs, FSG submission forms, and external integrations — can determine whether the currently logged-in user is permitted to use a given report set.

The view is the object surfaced when a report set must be identified by name and description but the underlying security model must remain enforced. Rather than requiring every caller to invoke FND_DATA_SECURITY directly, the view centralizes the privilege check, which is a common EBS design pattern for data-security-wrapped objects.

Underlying Base Objects

The view is defined with a single SELECT from RG_REPORT_SETS, exposed in the APPS schema as a synonym. Two PL/SQL packages are referenced by the view text:

• RG_REPORT_SETS — the base synonym holding the report set definition rows (report set ID, name, description, application, flexfield code, structure, and security flag).
• FND_DATA_SECURITY (PACKAGE) — provides CHECK_FUNCTION, which evaluates whether the current user may access the report set.
• FND_GLOBAL (PACKAGE) — provides USER_NAME, supplying the identity passed into the security check.

The view therefore couples the RG_REPORT_SETS data with the Application Object Library security engine. No aggregation or join to dimension tables occurs; the transformation is limited to the computed USE_PRIVILEGE column.

Key Columns

• REPORT_SET_ID — unique identifier of the FSG report set; the key used in the security check (converted with TO_CHAR).
• NAME — the user-defined report set name.
• DESCRIPTION — free-text description of the report set.
• APPLICATION_ID — owning application identifier (typically General Ledger).
• ID_FLEX_CODE — the key flexfield code associated with the report set.
• STRUCTURE_ID — the accounting flexfield structure to which the report set applies.
• USE_PRIVILEGE — derived column. When SECURITY_FLAG is 'Y', CHECK_FUNCTION is invoked with the function name 'GL_DAS_FSG_REPORT_SET_U' and data group 'GL_DAS_FSG_REPORT_SET'; the returned status of 'T' is mapped to 'Y', otherwise 'N'. Where SECURITY_FLAG is not 'Y', the outer DECODE yields 'Y' by default.

The literal 'GL_DAS_FSG_REPORT_SET_U' corresponds directly to the user's search term gl_das_fsg_report_set_u, confirming that the view is the catalog object that references that security function.

Common Use Cases and Queries

Typical consumers enumerate report sets visible to a user, or verify entitlement before allowing an FSG run:

• Listing accessible report sets for a responsibility.
• Validating a report set ID prior to submission.
• Reporting on report set metadata for audit or migration analysis.

Sample query:

SELECT report_set_id, name, description, application_id, id_flex_code, structure_id, use_privilege FROM apps.rg_report_set_name_v WHERE use_privilege = 'Y' ORDER BY name;

Because USE_PRIVILEGE is evaluated for FND_GLOBAL.USER_NAME, the result set is session-dependent; the same query may return different rows for different users or responsibilities. Any query filtering or reporting on this view should therefore be executed in the intended user context, and cached results should not be reused across sessions.