FND Users – 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

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

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, 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

AP Suppliers, FND Responsibility Access, FND User Upload, Blitz Report User History, INV Item Upload 11i, INV Items, INV Item 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 FND Users 02-Mar-2021 114505.xlsx
Blitz Report™ XML Import FND_Users.xml
SQL Source FND Users.sql
Full Report 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.

© Enginatics GmbH