Search Results gl_access_sets_v




Overview
Explore in AI Chat

Overview

GL_ACCESS_SETS_V is an APPS-owned database view in the Oracle E-Business Suite General Ledger (GL) module. It exposes the definition of General Ledger access sets, which are the mechanism by which a responsibility is granted read and write privileges to one or more ledgers, and by which segment value security is enforced across those ledgers. An access set binds a chart of accounts, a security segment, a secured segment value set, and an accounting period type to a set of ledgers, enabling consolidated or restricted access to financial data.

Because the view resolves foreign keys and joins descriptive attributes, it presents access set information in a report-friendly, denormalized form. This makes it suitable for reporting, data extraction, and integration scenarios where the numeric identifiers stored in the base table are insufficient and human-readable names are required. The view is widely referenced by Oracle's own concurrent programs and by custom reporting that must determine which ledgers and segment value sets a given access set controls.

Underlying Base Objects

The view is defined over four base objects, all accessed through APPS synonyms:

  • GL_ACCESS_SETS — the primary table, aliased GA, holding the access set definition, including the secured segment value set and chart of accounts references.
  • FND_ID_FLEX_STRUCTURES_TL — aliased FS, the translated key flexfield structure table, used to resolve the chart of accounts name. The join is restricted to APPLICATION_ID = 101 (General Ledger), ID_FLEX_CODE = 'GL#', and the session language via USERENV('LANG').
  • GL_PERIOD_TYPES — aliased GPT, joined on ACCOUNTED_PERIOD_TYPE to supply the user period type.
  • GL_LEDGERS — aliased GLD, outer-joined on DEFAULT_LEDGER_ID to supply the default ledger name. The (+) outer join permits access sets with no default ledger.

Key Columns

Common Use Cases and Queries

Typical usages include listing access sets for a ledger or chart of accounts, identifying the secured segment value set for a security configuration review, and joining to value set tables to enumerate secured values.

List enabled access sets with their chart of accounts and secured value set:

SELECT access_set_id, name, chart_of_accounts_name,
       security_segment_code, secured_seg_value_set_id,
       default_ledger_name
FROM   apps.gl_access_sets_v
WHERE  enabled_flag = 'Y'
ORDER BY name;

Locate access sets by secured segment value set:

SELECT access_set_id, name, security_segment_code
FROM   apps.gl_access_sets_v
WHERE  secured_seg_value_set_id = :value_set_id;

Retrieve access sets tied to a specific ledger as default:

SELECT access_set_id, name, default_ledger_name
FROM   apps.gl_access_sets_v
WHERE  default_ledger_id = :ledger_id;

Because the view is defined in the APPS schema, reporting queries should reference it as APPS.GL_ACCESS_SETS_V and account for the language-restricted chart of accounts name, which returns only the structure name for the current session language.