FND Roles – Oracle EBS SQL Report

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

Overview

Report of all User Management (UMX) roles, including number of active users for each role to help managing role-based access control (RBAC)

Report Parameters

Role Name, Role Code, Active only

Oracle EBS Tables Used

wf_user_role_assignments, wf_local_roles, wf_local_roles_tl, fnd_responsibility_vl

Report Categories

Enginatics

FND User Roles 11i, FND User Roles, OKL Termination Quotes

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 Roles 10-Jan-2021 134007.xlsx
Blitz Report™ XML Import FND_Roles.xml
Full SQL on Enginatics www.enginatics.com/reports/fnd-roles/

Executive Summary

The FND Roles report provides a directory of all User Management (UMX) roles defined in the system, along with a count of active users assigned to each role. It serves as a high-level inventory for managing Role-Based Access Control (RBAC).

Business Challenge

As organizations evolve, the number of defined roles can grow significantly. Administrators often struggle to keep track of which roles are active, which are obsolete, and how widely each role is used. “Zombie” roles (roles with no users) clutter the system and confuse security administration.

The Solution

This report gives a clear inventory of roles. By including the active user count, it immediately highlights:

Technical Architecture

The report aggregates data from wf_local_roles to identify roles and wf_user_role_assignments to calculate the count of active user assignments.

Parameters & Filtering

Performance & Optimization

The report performs an aggregation to count users. On systems with a very large number of users and complex role assignments, this aggregation may take a moment, but it is generally performant.

FAQ

Q: Does this report show the permissions inside the role? A: No, this is a role inventory. To see the hierarchy of the role, use FND Role Hierarchy. To see what responsibilities are in a role, you would need to look at the role assignment details.

Q: What types of roles are included? A: It includes UMX roles and can include other Workflow roles depending on the system configuration, as they share the underlying Workflow directory service tables.

© 2026 Enginatics