Search Results segment_display_name

Overview

The view RG_REPORT_AXIS_SETS_V is an Oracle Application Report Generator (RG) dictionary object owned by the APPS schema. It exposes the definition of report axis sets — the row sets and column sets used by the General Ledger Financial Statement Generator (FSG) and related reporting components — together with dynamically evaluated privilege information for the current user. The _V suffix denotes a database view rather than a base table; the view is reported as VALID under both Oracle EBS 12.1.1 and 12.2.2, and its structure in the ETRM metadata is consistent across those releases.

The role of the view is twofold. First, it presents the full physical definition of each axis set stored in RG_REPORT_AXIS_SETS, including application context, flexfield references, descriptive attributes, and the assignment of an XBRL taxonomy. Second, it computes three derived privilege columns — VIEW_PRIVILEGE, USE_PRIVILEGE, and MODIFY_PRIVILEGE — by invoking the Data Security function FND_DATA_SECURITY.CHECK_FUNCTION. This makes the view the natural access point for reporting and integration logic that must honor row-set and column-set security while reading axis set definitions.

Underlying Base Objects

The documented referenced base objects for this view are:

• RG_REPORT_AXIS_SETS (SYNONYM) — the primary source, aliased AXS, supplying axis set identity, descriptive, and audit columns.
• FND_ID_FLEX_SEGMENTS (SYNONYM) — aliased FLX in the view text, joined to supply the display name and numeric position of the segment referenced by the axis set.
• RG_XBRL_TAXONOMIES (SYNONYM) — aliased TAX, joined to supply taxonomy identity and descriptive attributes.
• FND_DATA_SECURITY (PACKAGE) — invoked through CHECK_FUNCTION to evaluate per-user privileges against the appropriate FSG security function.
• FND_GLOBAL (PACKAGE) — used to obtain the current user name (FND_GLOBAL.USER_NAME) passed as an argument to the security check.

When SECURITY_FLAG is Y, the view calls the data security function with a function name of GL_DAS_FSG_ROW_SET_V, GL_DAS_FSG_COLUMN_SET_V, GL_DAS_FSG_ROW_SET_U, GL_DAS_FSG_COLUMN_SET_U, GL_DAS_FSG_ROW_SET_M, or GL_DAS_FSG_COLUMN_SET_M, depending on whether the axis set type is a row set (R) or a column set, and whether the operation is view, use, or modify. A SECURITY_FLAG value of T forces all three privileges to Y; any other value yields N.

Key Columns

• AXIS_SET_ID, APPLICATION_ID, NAME, DESCRIPTION, AXIS_SET_TYPE — identity and classification of the axis set. AXIS_SET_TYPE distinguishes row sets from column sets.
• SECURITY_FLAG, DISPLAY_IN_LIST_FLAG — control whether data security is enforced and whether the set appears in selection lists.
• PERIOD_SET_NAME — the accounting period set associated with the axis set.
• COLUMN_SET_HEADER, SEGMENT_NAME, SEGMENT_DISPLAY_NAME, SEGMENT_NUM, ID_FLEX_CODE, STRUCTURE_ID, CONTEXT — flexfield and segment definition attributes, with SEGMENT_DISPLAY_NAME resolved from FND_ID_FLEX_SEGMENTS.
• TAXONOMY_ID, TAXONOMY_NAME, TAXONOMY_DESCR, TAXONOMY_IMPORT_FLAG — XBRL taxonomy assignment for the set.
• ATTRIBUTE1 through ATTRIBUTE15 — descriptive flexfield attribute columns carried from the base table.
• ROW_ID, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard WHO audit columns.
• VIEW_PRIVILEGE, USE_PRIVILEGE, MODIFY_PRIVILEGE — derived Y/N flags indicating the current user's rights to view, use, or modify each axis set.

Common Use Cases and Queries

A typical use is to list the row sets and column sets visible to the current user, filtered by privilege. The following query retrieves axis sets the user may at least view:

• SELECT axis_set_id, name, axis_set_type, view_privilege, use_privilege, modify_privilege FROM rg_report_axis_sets_v WHERE view_privilege = 'Y' ORDER BY name;
• SELECT axis_set_id, name, segment_display_name, segment_num, id_flex_code FROM rg_report_axis_sets_v WHERE axis_set_type = 'R' AND security_flag = 'Y';
• SELECT axis_set_id, name, taxonomy_name, taxonomy_import_flag FROM rg_report_axis_sets_v WHERE taxonomy_id IS NOT NULL;

Because privilege evaluation is performed per row through FND_DATA_SECURITY.CHECK_FUNCTION and FND_GLOBAL, queries against this view should be restricted with predicates on identity or type columns to avoid evaluating security across the entire axis set population. Integration code that reads FSG definitions should prefer this view over RG_REPORT_AXIS_SETS when user-level access enforcement is required.