Search Results gl_access_sets
The GL_ACCESS_SETS table in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 is a critical repository for defining and managing data access control within the General Ledger (GL) module. It serves as the foundation for implementing the Data Access Set (DAS) security model, which governs user access to ledger, balancing segment, and management segment values. This table is part of Oracle's robust security framework, ensuring compliance with segregation of duties (SoD) and regulatory requirements.
Purpose and Functionality
The primary purpose of the GL_ACCESS_SETS table is to store metadata about access sets, which determine the scope of financial data a user can view or modify. Each access set defines:- Ledger Access: Specifies which ledgers a user can access.
- Balancing Segment Access: Controls access to balancing segment values (e.g., cost centers, departments).
- Management Segment Access: Restricts access to management segment values (if configured).
Key Columns in GL_ACCESS_SETS
The table includes several important columns that define access set properties:- ACCESS_SET_ID: Primary key, uniquely identifying each access set.
- NAME: User-defined name of the access set (e.g., "US_Ledgers_Read_Only").
- SECURITY_SEGMENT_CODE: Indicates whether security applies to balancing ('B'), management ('M'), or both ('A') segments.
- CHART_OF_ACCOUNTS_ID: References the chart of accounts structure.
- PERIOD_SET_NAME: Associates the access set with a calendar.
- DEFAULT_LEDGER_ID: Specifies the default ledger for the access set.
- STATUS: Active ('A') or inactive ('I') status flag.
Integration with Other Modules
The GL_ACCESS_SETS table integrates with multiple Oracle EBS components:- Subledger Accounting (SLA): Ensures SLA rules respect GL access restrictions.
- Financial Reporting: Limits report data based on assigned access sets.
- Multi-Org Access Control (MOAC): Works in tandem with MOAC to enforce data security across operating units.
Implementation Considerations
When configuring access sets in Oracle EBS 12.1.1 or 12.2.2:- Hierarchy: Access sets follow a hierarchical model where more restrictive definitions override broader ones.
- Performance: Complex access set definitions with numerous ledger/segment restrictions may impact query performance.
- Audit: The table's data is critical for SOX and financial audits, as it documents who can access what data.
Technical Details
The table resides in the APPS schema and is part of the General Ledger product family. In EBS 12.2.2, it may leverage Oracle's Online Patching (ADOP) framework for maintenance. Typical size ranges from a few dozen to several hundred rows, depending on organizational complexity.Best Practices
- Maintain a naming convention that reflects access set purpose (e.g., "Region_EU_Write").
- Regularly review inactive access sets to purge obsolete entries.
- Document access set assignments in a controlled manner for audit trails.
-
Table: GL_ACCESS_SETS
12.2.2
owner:GL, object_type:TABLE, fnd_design_data:SQLGL.GL_ACCESS_SETS, object_name:GL_ACCESS_SETS, status:VALID, product: GL - General Ledger , description: Data access set definitions , implementation_dba_data: GL.GL_ACCESS_SETS ,
-
Table: GL_ACCESS_SETS
12.1.1
owner:GL, object_type:TABLE, fnd_design_data:SQLGL.GL_ACCESS_SETS, object_name:GL_ACCESS_SETS, status:VALID, product: GL - General Ledger , description: Data access set definitions , implementation_dba_data: GL.GL_ACCESS_SETS ,
-
APPS.GL_GLXRBUDA_XMLP_PKG dependencies on GL_ACCESS_SETS
12.1.1
-
APPS.GL_RGXCOLD_XMLP_PKG dependencies on GL_ACCESS_SETS
12.1.1
-
APPS.GL_FLATTEN_ACCESS_SETS dependencies on GL_ACCESS_SETS
12.1.1
-
APPS.GL_GLXRCTRS_XMLP_PKG dependencies on GL_ACCESS_SETS
12.1.1
-
APPS.GL_GLXRBJRN_XMLP_PKG dependencies on GL_ACCESS_SETS
12.1.1
-
APPS.JG_JGZZGLJRN_XMLP_PKG dependencies on GL_ACCESS_SETS
12.1.1
-
APPS.GL_SEL_SEG_TURNOVER_RPT_PKG dependencies on GL_ACCESS_SETS
12.1.1
-
APPS.GL_RGXRORDD_XMLP_PKG dependencies on GL_ACCESS_SETS
12.1.1
-
APPS.GL_GLXRBDHR_XMLP_PKG dependencies on GL_ACCESS_SETS
12.1.1
-
APPS.GL_GLXRLVAT_XMLP_PKG dependencies on GL_ACCESS_SETS
12.1.1
-
APPS.GL_LEDGER_UTILS_PKG dependencies on GL_ACCESS_SETS
12.2.2
-
APPS.GL_GLXETB_XMLP_PKG dependencies on GL_ACCESS_SETS
12.2.2
-
APPS.GL_SECURITY_PKG dependencies on GL_ACCESS_SETS
12.2.2
-
APPS.GL_GLRFGNJ_XMLP_PKG dependencies on GL_ACCESS_SETS
12.2.2
-
APPS.GL_GLXRBJRN_XMLP_PKG dependencies on GL_ACCESS_SETS
12.2.2
-
APPS.GL_GLXRLBOL_XMLP_PKG dependencies on GL_ACCESS_SETS
12.2.2
-
APPS.GL_GLRGNL_XMLP_PKG dependencies on GL_ACCESS_SETS
12.2.2
-
APPS.GL_RGXRPTD_XMLP_PKG dependencies on GL_ACCESS_SETS
12.2.2
-
APPS.GL_CASH_CLR_ACCT_ANAL_RPT_PKG dependencies on GL_ACCESS_SETS
12.1.1
-
APPS.GL_GLXRLBOL_XMLP_PKG dependencies on GL_ACCESS_SETS
12.1.1
-
APPS.XLA_TRANSFER_PKG dependencies on GL_ACCESS_SETS
12.1.1
-
APPS.GL_GLRJED_XMLP_PKG dependencies on GL_ACCESS_SETS
12.1.1
-
APPS.JG_JGZZGLJRB_XMLP_PKG dependencies on GL_ACCESS_SETS
12.1.1
-
APPS.GL_GLXJETAX_XMLP_PKG dependencies on GL_ACCESS_SETS
12.1.1
-
APPS.GL_GLXAVADT_XMLP_PKG dependencies on GL_ACCESS_SETS
12.1.1
-
APPS.GL_JE_SEGMENT_VALUES_PKG dependencies on GL_ACCESS_SETS
12.1.1
-
APPS.GL_GLWACCTR_XMLP_PKG dependencies on GL_ACCESS_SETS
12.1.1
-
APPS.JA_CN_SYSOPS_BANK_PKG dependencies on GL_ACCESS_SETS
12.2.2
-
APPS.GL_GLRJED_XMLP_PKG dependencies on GL_ACCESS_SETS
12.2.2
-
APPS.GL_RGXRPTS_XMLP_PKG dependencies on GL_ACCESS_SETS
12.2.2
-
APPS.GL_OPEN_BAL_REVAL_RPT_PKG dependencies on GL_ACCESS_SETS
12.2.2
-
APPS.GL_GLXAVADT_XMLP_PKG dependencies on GL_ACCESS_SETS
12.2.2
-
APPS.AR_DEP_BAL_RPT_PKG dependencies on GL_ACCESS_SETS
12.2.2
-
APPS.JL_JGZZGLTRB_XMLP_PKG dependencies on GL_ACCESS_SETS
12.2.2
-
APPS.GL_RGXCOND_XMLP_PKG dependencies on GL_ACCESS_SETS
12.2.2
-
APPS.GL_GLXJETAX_XMLP_PKG dependencies on GL_ACCESS_SETS
12.2.2
-
APPS.GL_RGXRSETD_XMLP_PKG dependencies on GL_ACCESS_SETS
12.2.2
-
APPS.XLA_JE_VALIDATION_PKG dependencies on GL_ACCESS_SETS
12.2.2
-
APPS.GL_RGXROWD_XMLP_PKG dependencies on GL_ACCESS_SETS
12.2.2
-
APPS.GL_GLYRLBGE_XMLP_PKG dependencies on GL_ACCESS_SETS
12.2.2
-
APPS.GL_LEDGER_UTILS_PKG dependencies on GL_ACCESS_SETS
12.1.1
-
APPS.GL_CI_REMOTE_INVOKE_PKG dependencies on GL_ACCESS_SETS
12.1.1
-
APPS.JL_JGZZGLTRB_XMLP_PKG dependencies on GL_ACCESS_SETS
12.1.1
-
APPS.GL_OPEN_BAL_REVAL_RPT_PKG dependencies on GL_ACCESS_SETS
12.1.1
-
APPS.GL_RGXROWS_XMLP_PKG dependencies on GL_ACCESS_SETS
12.1.1
-
APPS.GL_AUTO_ALLOC_WF_PKG dependencies on GL_ACCESS_SETS
12.1.1
-
APPS.AR_DEP_BAL_RPT_PKG dependencies on GL_ACCESS_SETS
12.1.1
-
APPS.GL_GLRFGNJ_XMLP_PKG dependencies on GL_ACCESS_SETS
12.1.1