Search Results gl_access_sets

Overview

The GL_ACCESS_SETS table is a core repository for data access set definitions within the Oracle E-Business Suite General Ledger module. A data access set is a fundamental security mechanism that controls user access to ledgers, ledger sets, and their balancing segment values or management segment values. It defines which chart of accounts structures and specific data ranges a responsibility or user can view and post transactions against. This table stores the master definition of these access sets, which are then assigned to responsibilities via the GL Access Set Assignments form. Its role is central to implementing a multi-organization or multi-ledger security model, ensuring financial data integrity and segregation of duties across the enterprise.

Key Information Stored

The table's primary structure includes the ACCESS_SET_ID, which serves as the unique system-generated identifier (and primary key) for each access set definition. While the provided ETRM excerpt does not list all columns, based on its functional purpose, the table typically stores columns such as NAME (the user-defined name of the access set), DESCRIPTION, SECURITY_SEGMENT_CODE (indicating whether security is applied at the Balancing or Management segment level), and CHART_OF_ACCOUNTS_ID. It also holds creation and last update metadata. The ACCESS_SET_ID column is critical as it is referenced by numerous other entities to enforce data access rules.

Common Use Cases and Queries

Primary use cases involve security administration and auditing. Administrators may query this table to list all defined access sets or to troubleshoot user access issues by joining to responsibility assignment tables. A common reporting query retrieves basic access set information for a review of security configurations. For example:

• SELECT access_set_id, name, description FROM gl.gl_access_sets WHERE enabled_flag = 'Y' ORDER BY name;

Another critical scenario is identifying which ledgers or balancing segment values are secured by a specific access set, which requires joining to related tables like GL_ACCESS_SET_ASSIGNMENTS and GL_ACCESS_SET_LEDGERS. Developers may also reference this table when writing custom reports or interfaces to ensure data is filtered according to the user's assigned access set, often leveraging the GL_ACCESS_SET_PKG APIs.

Related Objects

As indicated by the foreign key relationships in the metadata, GL_ACCESS_SETS is a parent table to several key objects. The GL_LEDGERS table references it via the IMPLICIT_ACCESS_SET_ID column, linking to the default access set automatically created for each ledger. The GL_AUTO_ALLOC_SET_HISTORY table also references it, tying allocation process history to a specific access set context. Furthermore, it is intrinsically linked to child tables such as GL_ACCESS_SET_ASSIGNMENTS (which assigns access sets to responsibilities) and GL_ACCESS_SET_LEDGERS (which defines the specific ledgers and segment value ranges within the set). Programmatically, the GL_ACCESS_SET_PKG package provides APIs for validating and working with access set data.