Search Results gl_access_set_assignments




Overview
Explore in AI Chat

Overview

The GL_ACCESS_SET_ASSIGNMENTS table is a core data security object within Oracle E-Business Suite General Ledger (GL), specifically for releases 12.1.1 and 12.2.2. It stores the flattened, or denormalized, privilege assignments for Data Access Sets. A Data Access Set is a key security construct that controls user access to ledgers, balancing segment values, and management segment values. This table acts as the underlying repository that materializes the complex security rules defined in the user interface, enabling the efficient enforcement of data access privileges during transaction posting, journal entry, and financial reporting. Its role is critical for ensuring that users can only view and post transactions to the specific ledgers and accounting flexfield value combinations they are authorized to access.

Key Information Stored

The table's structure, as indicated by its primary key, is designed to uniquely identify a specific access privilege. The documented columns are integral to this security model. The ACCESS_SET_ID column stores the unique identifier for the Data Access Set definition. The LEDGER_ID column identifies the specific ledger to which access is being controlled. The SEGMENT_VALUE column holds the specific accounting flexfield segment value (e.g., a particular cost center or department code) for which access is granted within the designated ledger. The combination of these three fields, forming the primary key (GL_ACCESS_SET_ASSIGNMENTS_PK), defines a single, granular data access rule.

Common Use Cases and Queries

This table is primarily accessed for security auditing, troubleshooting access issues, and generating custom security reports. A common scenario involves identifying all segment values a specific user can access for a given ledger. This requires joining through security assignment tables to user roles. A typical audit query would list all assignments for a known Data Access Set:

  • SELECT access_set_id, ledger_id, segment_value FROM gl_access_set_assignments WHERE access_set_id = :p_access_set_id ORDER BY ledger_id, segment_value;

Another critical use case is diagnosing "No data found" or "Insufficient privileges" errors during journal entry. System administrators can query this table to verify if the intended ledger and segment value combination exists for the user's assigned Data Access Set. The table is also essential for custom reporting scripts that need to filter financial data based on the same security rules enforced by the GL application.

Related Objects

GL_ACCESS_SET_ASSIGNMENTS has a direct relationship with the core definition table for Data Access Sets. Based on the primary key structure, the ACCESS_SET_ID column is a foreign key referencing the GL_ACCESS_SETS table. The LEDGER_ID column is a foreign key referencing the GL_LEDGERS table. This table is populated and maintained by the application's security setup processes and is heavily referenced by the General Ledger's data access security engine (likely within packages like GL_DATA_ACCESS_SECURITY). Views such as GL_DATA_ACCESS_SET_LEDGERS may be built upon this table to present a more user-friendly perspective of the flattened assignments.