Search Results gl_defas_access_sets




Overview
Explore in AI Chat

Overview

The GL_DEFAS_ACCESS_SETS table is a core data object within the Oracle E-Business Suite (EBS) General Ledger (GL) module, specifically for versions 12.1.1 and 12.2.2. It serves as the master repository for definition access set definitions. In Oracle GL, a definition access set is a critical security mechanism that controls user access to key financial data definitions, such as value sets, key flexfield combinations, and other setup entities. This table stores the fundamental metadata for each access set, enabling the system to enforce data security and segregation of duties at the definitional level, which is foundational for maintaining data integrity and compliance in a multi-organization environment.

Key Information Stored

The primary purpose of this table is to store the unique identifier and descriptive attributes for each definition access set. The key column is DEFINITION_ACCESS_SET_ID, which serves as the primary key (GL_DEFAS_ACCESS_SETS_PK). While the provided ETRM excerpt is concise, standard implementation patterns suggest this table typically contains columns for the access set name, description, creation date, created by, last update date, last updated by, and potentially an enabled flag. The DEFINITION_ACCESS_SET_ID is the critical foreign key referenced by numerous child tables that define the specific data objects, rules, and organizations included within the access set's scope.

Common Use Cases and Queries

This table is central to administration and auditing of GL security setups. Common use cases include generating a list of all definition access sets for review, identifying access sets created or modified by specific users, and troubleshooting security-related issues. A typical reporting query would join this master table with related assignment tables to understand the full security model. For example:

  • Listing all access sets: SELECT definition_access_set_id, name, description, creation_date FROM gl_defas_access_sets ORDER BY name;
  • Identifying recently modified access sets: SELECT definition_access_set_id, name, last_update_date, last_updated_by FROM gl_defas_access_sets WHERE last_update_date > SYSDATE - 30;

Direct data manipulation (DML) on this table is strongly discouraged; access sets should be managed through the standard Oracle GL application interface to maintain referential integrity.

Related Objects

The GL_DEFAS_ACCESS_SETS table is at the apex of the definition access set security model. Its primary key, DEFINITION_ACCESS_SET_ID, is referenced as a foreign key by several child tables that define the specific components of an access set. Based on standard GL schema relationships, these related objects typically include:

  • GL_DEFAS_ACCESS_SET_ASSIGNMENTS: Links the access set to specific data definitions (e.g., value sets, flexfields). Joins on DEFINITION_ACCESS_SET_ID.
  • GL_DEFAS_ACCESS_SET_RULES: Stores the detailed security rules (like read-only or full access) for the assigned definitions. Joins on DEFINITION_ACCESS_SET_ID.
  • GL_DEFAS_ACCESS_SET_ORGS: Associates the access set with specific operating units or organizations to enforce data access. Joins on DEFINITION_ACCESS_SET_ID.

These relationships ensure that the master definition in GL_DEFAS_ACCESS_SETS governs a complete and enforceable security framework.