Search Results automatically_created_flag

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

• ACCESS_SET_ID — primary identifier of the access set.
• NAME — the user-defined access set name.
• SECURITY_SEGMENT_CODE — the segment (for example, Company or Cost Center) against which security is applied.
• SECURED_SEG_VALUE_SET_ID — the identifier of the segment value set that supplies the secured values. This is the column most commonly used to link an access set to its underlying value set and to the FND_FLEX_VALUES hierarchy.
• CHART_OF_ACCOUNTS_ID / CHART_OF_ACCOUNTS_NAME — the key flexfield structure identifier and its translated name.
• PERIOD_SET_NAME, USER_PERIOD_TYPE, ACCOUNTED_PERIOD_TYPE — the accounting calendar and period type attributes.
• DEFAULT_LEDGER_ID / DEFAULT_LEDGER_NAME — the ledger designated as default, when one exists.
• ENABLED_FLAG, AUTOMATICALLY_CREATED_FLAG — status and creation method indicators.
• DESCRIPTION, CONTEXT, ATTRIBUTE1–ATTRIBUTE15 — descriptive and descriptive flexfield columns.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

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.