FND Users – Oracle EBS SQL Report

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

Overview

Listing of all EBS users, their status, responsibility count, and if they were using blitz reports

Report Parameters

User Name, Has Access to Responsibility, Has Access to Application, Active only, Creation Date From, Creation Date To, Created within days

Oracle EBS Tables Used

fnd_user_resp_groups, fnd_responsibility, fnd_user, per_all_people_f, xxen_report_runs

Report Categories

Enginatics

FND Responsibility Access 11i, FND Responsibility Access, FND User Upload, Blitz Report User History, INV Item Upload, INV Items, Blitz Report Assignments and Responsibilities, GL Account Analysis, GL Account Distribution Analysis

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 Users 02-Mar-2021 114505.xlsx
Blitz Report™ XML Import FND_Users.xml
Full SQL on Enginatics www.enginatics.com/reports/fnd-users/

Executive Summary

The FND Users report provides a master inventory of all users defined in the Oracle EBS system. It includes status information, creation details, and a count of assigned responsibilities, offering a high-level view of the user base.

Business Challenge

System administrators need a quick way to answer basic questions about the user population: “How many active users do we have?”, “Who are the new users created this week?”, or “Which users have no responsibilities assigned?”.

The Solution

This report provides a flat listing of users with key attributes. It helps with:

Technical Architecture

The report queries the fnd_user table and aggregates data from fnd_user_resp_groups to provide the responsibility count. It also links to per_all_people_f to show the associated employee record.

Parameters & Filtering

Performance & Optimization

The report is very fast as it primarily queries the user master table.

FAQ

Q: Does this show the last login time? A: This report focuses on user definition. For login activity, use the FND User Login History or FND User Login Summary reports.

Q: What does “Responsibility Count” tell me? A: It indicates the number of responsibilities assigned to the user. A count of 0 might indicate a service account or a user that has been effectively disabled by removing all access.

© 2026 Enginatics