FND User Responsibilities – Oracle EBS SQL Report

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

Overview

Similar to report FND Responsibility Access, but also shows inactive / end dated user responsibilities while FND Access Control shows currently active assigned responsibilities only. Same as Oracle’s ‘Active Users’ report.

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

User Name, Responsibility Name, Application, Active only, End Dated from

Oracle EBS Tables Used

fnd_user_resp_groups_direct, fnd_user_resp_groups_indirect, fnd_user, fnd_responsibility_vl, fnd_application_vl

Report Categories

Enginatics

Blitz Report Template Sharing, AP Suppliers, FND User Upload, FND User Roles, INV Cycle count listing, Blitz Report User History, INV Cycle count entries and adjustments, INV Cycle counts pending approval

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 FND User Responsibilities 30-Sep-2018 174651.xlsx
Blitz Report™ XML Import FND_User_Responsibilities.xml
SQL Source FND User Responsibilities.sql
Full Report on Enginatics www.enginatics.com/reports/fnd-user-responsibilities/

Executive Summary

The FND User Responsibilities report provides a comprehensive view of responsibility assignments to users. Unlike standard active-only reports, this report can include inactive and end-dated assignments, making it a powerful tool for historical auditing and access troubleshooting.

Business Challenge

Standard Oracle forms often hide end-dated records, making it difficult to answer questions like “Did this user have access to the General Ledger last month?” or “When was this user’s access revoked?”. Auditors often require proof not just of current access, but of the history of access changes.

The Solution

This report lists user responsibility assignments with their effective start and end dates. It allows administrators to:

Technical Architecture

The report queries fnd_user_resp_groups_direct and fnd_user_resp_groups_indirect to capture all assignment types. It joins with fnd_user and fnd_responsibility_vl for descriptive names.

Parameters & Filtering

Performance & Optimization

The report is efficient. Using the Active only parameter can reduce the dataset size significantly in older systems with many historical records.

FAQ

Q: What is the difference between direct and indirect responsibility? A: A direct responsibility is assigned explicitly to the user. An indirect responsibility is inherited because the user was assigned a Role (e.g., via User Management) that contains the responsibility.

Q: Does this show which user granted the access? A: It shows the CREATED_BY and LAST_UPDATED_BY columns, which indicate who performed the assignment (or if it was done by a system process like AUTOINSTALL).

© Enginatics GmbH