Skip to the content.

GL Data Access Sets – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™. Oracle EBS module: General Ledger · all General Ledger reports

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.

Show Responsibilities adds one row per responsibility using the access set through the GL: Data Access Set profile set at responsibility or application level. Responsibilities inheriting the site level value are not listed.

Summary Accounts Allowed shows Yes when the responsibility’s menu grants the Summary Accounts form and the access set gives full read and write access to the whole ledger. Otherwise the form’s Ledger list does not offer the ledger (FRM-41830 List of Values contains no entries).

Run this report in Excel in seconds: download Blitz Report™ free (your first 30 reports are free) or try it in the online demo.

Report Parameters

Access Set, Ledger, Access Set Type, Show Responsibilities, Summary Accounts Allowed

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

FND Responsibility Access, FND Responsibilities, GL Setup Upload, GL Ledger Sets, Blitz Report Security, IBY Payment Process Request Details, GL Ledgers and Legal Entities, AP Supplier Upload

Running This SQL Without Blitz Report

The SQL source can be run in any SQL client. Some Oracle EBS SQL reports in this library use functions from the utility package xxen_util – install it first. Blitz Report™ adds parameters, Excel output with pivots, scheduling and security on top.

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
SQL Source GL Data Access Sets.sql
Full Report 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

Technical Analysis

Core Tables

Key Joins & Logic

Key Parameters


© Enginatics GmbH