FND User Responsibilities – Oracle EBS SQL Report

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

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.

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

FND User Upload, CAC Material Account Detail, CAC ICP PII Material Account Detail, CAC Inventory Pending Cost Adjustment, CAC ICP PII Inventory Pending Cost Adjustment, FND User Roles 11i, FND User Roles, INV Cycle count listing, INV Cycle counts pending approval

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 FND User Responsibilities 30-Sep-2018 174651.xlsx
Blitz Report™ XML Import FND_User_Responsibilities.xml
Full SQL 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).

© 2026 Enginatics