Skip to content

GL Data Access Sets

Directory actions

More options

Directory actions

More options

Latest commit

 

History

History

GL Data Access Sets

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
DESCRIPTION.md
DESCRIPTION.md
 
 
GL Data Access Sets.sql
GL Data Access Sets.sql
 
 
README.md
README.md
 
 

README.md

layout default
title GL Data Access Sets | Oracle EBS SQL Report
description Master data report showing ledger security. Listing of all GL data access sets and the ledgers or ledger sets that each access set can access.
keywords Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, R12 only, Data, Access, Sets, gl_access_sets_v, gl_access_set_norm_assign, gl_ledger_set_norm_assign_v
permalink /GL%20Data%20Access%20Sets/

GL Data Access Sets – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.

Overview

Master data report showing ledger security. Listing of all GL data access sets and the ledgers or ledger sets that each access set can access.

Report Parameters

Access Set

Oracle EBS Tables Used

gl_access_sets_v, gl_access_set_norm_assign, gl_ledger_set_norm_assign_v, gl_ledgers

Report Categories

Enginatics, R12 only

Related Reports

CAC Cost vs. Planning Item Controls, CAC Material Overhead Setup, CAC Inventory Organization Summary, CAC ICP PII Inventory Pending Cost Adjustment, CAC Inventory and Intransit Value (Period-End), CAC ICP PII Inventory and Intransit Value (Period-End), CAC New Standard Item Costs, CAC Standard Cost Update Submissions, CAC User-Defined and Rolled Up Costs

Running This SQL Without Blitz Report

Some Oracle EBS SQL reports in this library require functions from the utility package xxen_util. Install it before running the SQL directly against your Oracle EBS database.

Download & Import Options

Resource Link
Excel Example Output GL Data Access Sets 12-Apr-2019 022216.xlsx
Blitz Report™ XML Import GL_Data_Access_Sets.xml
Full SQL on Enginatics www.enginatics.com/reports/gl-data-access-sets/

GL Data Access Sets - Case Study & Technical Analysis

Executive Summary

The GL Data Access Sets report analyzes the security configuration of the General Ledger, specifically focusing on Data Access Sets. It details which ledgers and ledger sets are accessible to specific users or responsibilities, ensuring proper segregation of duties and data security. This report is a key component of system administration and internal audit workflows, providing visibility into "who can see what" within the financial system.

Business Use Cases

  • Security Audit: Verifies that users only have access to the ledgers relevant to their role (e.g., ensuring US users access only US ledgers and cannot view or post to European ledgers).
  • System Administration: Assists in troubleshooting "access denied" issues or empty reports by confirming the active Data Access Set configuration for a specific responsibility.
  • Compliance Reporting: Documents data access controls for SOX (Sarbanes-Oxley) or internal audit requirements, proving that financial data is protected from unauthorized access.
  • Implementation Verification: Validates that the complex hierarchy of Ledgers and Ledger Sets has been correctly mapped to Data Access Sets during system setup.

Technical Analysis

Core Tables

  • GL_ACCESS_SETS: Defines the header information for a data access set (Name, Security Code, Chart of Accounts ID).
  • GL_ACCESS_SET_ASSIGNMENTS: Maps the Data Access Set to specific Ledgers or Ledger Sets.
  • GL_LEDGERS: Stores details about the ledgers themselves.
  • GL_LEDGER_SET_NORM_ASSIGN_V: A view that helps resolve the flattened list of ledgers contained within a Ledger Set.

Key Joins & Logic

  • Access Mapping: The query joins GL_ACCESS_SETS to GL_ACCESS_SET_ASSIGNMENTS to find the scope of access.
  • Ledger Resolution: It links to GL_LEDGERS to retrieve the names of the accessible entities.
  • Hierarchy Flattening: A Data Access Set can grant access to a "Ledger Set" (a group of ledgers). The report logic often needs to expand this Ledger Set to list the individual underlying ledgers to provide a complete picture of access.
  • Privilege Check: The report distinguishes between READ_ONLY and READ_WRITE privileges, which is stored in the assignment table.

Key Parameters

  • Access Set Name: The specific data access set to analyze.
  • Ledger Name: Filter to see which access sets provide access to a specific ledger.

Useful Links

© 2026 Enginatics