Search Results gl_das_fsg_column_set_v

Overview

The view APPS.RG_REPORT_AXIS_SETS_LOV_V is a security-aware list-of-values (LOV) view defined in the Oracle E-Business Suite APPS schema. It exposes the row and column axis sets that underpin Oracle General Ledger Financial Statement Generator (FSG) reports, presenting them together with dynamically computed access privileges for the current user. The view is part of the ETRM (E-Business Suite Technical Reference Manual) data model associated with the GL_DAS (Data Access Set / Financial Statement Generator) subsystem.

In Oracle EBS 12.1.1 and 12.2.2, this object is primarily consumed by FSG-related forms and concurrent programs to populate LOV windows for report axis sets. Its defining characteristic is embedded function security enforcement: rather than returning all rows, it evaluates data security and menu/function grants at runtime and returns privilege indicators that a calling form can use to enable or disable view, use, and modify actions. The user search term "gl_das_fsg_row_set_v" reflects the closely related row-set function names referenced inside this view's DECODE logic, which are the security function codes for FSG row sets.

The view therefore acts as both a data source and a lightweight authorization layer, avoiding the need for each calling form to re-implement privilege checks.

Underlying Base Objects

Per documented ETRM metadata, the view is defined over the following base objects:

• RG_REPORT_AXIS_SETS (referenced via a SYNONYM) — the base table holding FSG row and column axis set definitions, including name, description, security flag, structure, and ID flex code.
• FND_DATA_SECURITY (PACKAGE) — provides the CHECK_FUNCTION API, used to evaluate whether the current user holds the relevant function grant for a given axis set.
• FND_GLOBAL (PACKAGE) — supplies session context, notably USER_NAME, used in the privilege DECODE calls.

The view is a straight projection over RG_REPORT_AXIS_SETS with no joins or aggregations; all added complexity resides in the three DECODE expressions that wrap CHECK_FUNCTION. Because it is defined over the RG_REPORT_AXIS_SETS synonym, it remains consistent with the table's storage regardless of the underlying physical owner.

Key Columns

The view exposes the following columns:

• ROW_ID — the ROWID of the underlying RG_REPORT_AXIS_SETS row, used for row identification.
• NAME, DESCRIPTION — the axis set name and description shown in LOV windows.
• APPLICATION_ID — the owning application identifier.
• AXIS_SET_TYPE — indicates whether the axis set is a row set ('R') or a column set; this value drives the DECODE selection of the appropriate security function name throughout the view.
• AXIS_SET_ID — the unique identifier of the axis set, passed to CHECK_FUNCTION as the data-security argument.
• SECURITY_FLAG — when 'Y', security checking is performed; when 'T' or 'N', privileges default to 'Y' or 'N' respectively.
• STRUCTURE_ID, ID_FLEX_CODE — identify the accounting flexfield structure and key flexfield code associated with the axis set.
• VIEW_PRIVILEGE, USE_PRIVILEGE, MODIFY_PRIVILEGE — computed columns returning 'Y' or 'N', indicating whether the current user may view, use, or modify the axis set. These are derived by calling FND_DATA_SECURITY.CHECK_FUNCTION with the row-set or column-set function names (for example GL_DAS_FSG_ROW_SET_V, GL_DAS_FSG_ROW_SET_U, GL_DAS_FSG_ROW_SET_M) selected according to AXIS_SET_TYPE.

Common Use Cases and Queries

The view is typically queried by LOV-enabled forms and by custom reporting extensions that need to honour FSG axis set security. A representative query lists available row sets visible to the current user:

• Filter by AXIS_SET_TYPE = 'R' and VIEW_PRIVILEGE = 'Y' to obtain the row sets a user may select.
• Select AXIS_SET_ID and NAME together to populate a picker list.
• Use USE_PRIVILEGE or MODIFY_PRIVILEGE to gate edit or execution actions in a custom form.

Sample SQL:

• SELECT axis_set_id, name, description, view_privilege, use_privilege, modify_privilege FROM apps.rg_report_axis_sets_lov_v WHERE axis_set_type = 'R' AND view_privilege = 'Y' ORDER BY name;
• SELECT name, axis_set_type, structure_id, id_flex_code FROM apps.rg_report_axis_sets_lov_v WHERE security_flag = 'Y' AND use_privilege = 'Y';

Because privilege evaluation invokes FND_DATA_SECURITY.CHECK_FUNCTION and FND_GLOBAL.USER_NAME, results are session-dependent and reflect the responsibilities and function grants of the connected user. Developers integrating with FSG should query this view rather than RG_REPORT_AXIS_SETS directly when authorization must be enforced, ensuring that Oracle's native FSG security model (including the GL_DAS_FSG_ROW_SET and GL_DAS_FSG_COLUMN_SET function families) remains intact across both 12.1.1 and 12.2.2 environments.