Search Results gl_das_fsg_column_set_u




Overview
Explore in AI Chat

Overview

APPS.RG_REPORT_DISPLAY_SETS_V is an Oracle E-Business Suite view defined in the APPS schema that exposes header-level definitions of Oracle General Ledger Financial Statement Generator (FSG) report display sets. In the FSG model, a report display set is the top-level container that binds a row set (also known as a row axis set) to a column set (column axis set) to produce a runnable financial report. The view joins the display set definition to the underlying row and column axis sets so that descriptive names, in addition to numeric identifiers, are available for the constituent row set and column set.

Beyond simple denormalization, this view embeds data-security evaluation logic. It computes two privilege flags, ROW_SET_USE_PRIVILEGE and COL_SET_USE_PRIVILEGE, that reflect whether the current user is permitted to use the referenced row set and column set. These flags are derived by calling FND_DATA_SECURITY.CHECK_FUNCTION for the privileges GL_DAS_FSG_ROW_SET_U and GL_DAS_FSG_COLUMN_SET_U respectively. The view therefore acts as a security-filtered catalog of FSG display sets suitable for LOVs, concurrent program parameters, and reporting integrations.

Underlying Base Objects

The view is defined over the following documented objects:

  • RG_REPORT_DISPLAY_SETS (accessed via a synonym) — the primary base entity, aliased DS, holding the display set identifier, name, description, and the row set and column set foreign keys.
  • RG_REPORT_AXIS_SETS (accessed via a synonym) — joined twice: once as RS for the row set and once as CSET for the column set. Both joins are outer joins on AXIS_SET_ID, meaning display sets are returned even if a referenced axis set is missing.
  • FND_DATA_SECURITY (package) — invoked in the privilege DECODE expressions to evaluate function-based security against the current user.
  • FND_GLOBAL (package) — supplies USER_NAME to CHECK_FUNCTION.

Because RG_REPORT_DISPLAY_SETS and RG_REPORT_AXIS_SETS are referenced as synonyms, the underlying physical tables are owned by the Oracle General Ledger product schema (RG) rather than APPS.

Key Columns

  • ROW_ID — the physical ROWID of the display set row, useful for direct DML and row identification.
  • REPORT_DISPLAY_SET_ID — the primary key of the display set.
  • NAME and DESCRIPTION — the user-visible name and description of the display set.
  • ROW_SET_ID and ROW_SET — the identifier and resolved name of the associated row axis set.
  • COLUMN_SET_ID and COLUMN_SET — the identifier and resolved name of the associated column axis set.
  • ROW_SET_USE_PRIVILEGE and COL_SET_USE_PRIVILEGE — security flags returning 'Y' or 'N', indicating whether the current user may use the respective row or column set. When the axis set security flag is not 'Y', the privilege defaults to 'Y'.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard audit columns.
  • CONTEXT and ATTRIBUTE1 through ATTRIBUTE15 — descriptive flexfield (DFF) context and attribute columns.

Common Use Cases and Queries

A frequent requirement is to enumerate display sets the current user is authorized to run, which can be achieved by filtering on the computed privilege flags:

  • List all display sets with resolved row and column set names: SELECT REPORT_DISPLAY_SET_ID, NAME, ROW_SET, COLUMN_SET FROM APPS.RG_REPORT_DISPLAY_SETS_V ORDER BY NAME.
  • Restrict to sets where both components are usable: SELECT REPORT_DISPLAY_SET_ID, NAME FROM APPS.RG_REPORT_DISPLAY_SETS_V WHERE ROW_SET_USE_PRIVILEGE = 'Y' AND COL_SET_USE_PRIVILEGE = 'Y'.
  • Join to RG_REPORT_DISPLAY_SET_HEADERS or report request tables to determine which display sets feed a given FSG report run.

The view is well suited to LOV definitions, security-aware reporting catalogs, and integration queries that require both identifiers and descriptive names for FSG display sets. Note that the user search term "gl_das_fsg_row_set_u" corresponds to the privilege evaluated for the ROW_SET_USE_PRIVILEGE column in this view.