FND User Roles 11i – Oracle EBS SQL Report

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

Overview

Report for User Management (UMX) roles and their assigned users to manage role-based access control (RBAC)

Report Parameters

User Name, Role Name, Role Code, Active only

Oracle EBS Tables Used

wf_local_roles, wf_local_roles_tl, fnd_responsibility_vl, wf_local_user_roles, wf_user_role_assignments

Report Categories

Enginatics

FND User Roles, FND 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 None
Blitz Report™ XML Import FND_User_Roles_11i.xml
Full SQL on Enginatics www.enginatics.com/reports/fnd-user-roles-11i/

Executive Summary

The FND User Roles 11i report is the Oracle EBS 11i specific version of the User Roles report. It details the assignment of roles to users, supporting the management of Role-Based Access Control (RBAC) in older EBS environments.

Business Challenge

Even in 11i, RBAC concepts (via Workflow roles) were used for various approvals and access controls. Administrators need visibility into these assignments to ensure security policies are being followed and to troubleshoot workflow routing issues.

The Solution

This report lists users and their assigned roles, allowing administrators to:

Technical Architecture

The report queries the 11i versions of the Workflow directory service tables (wf_local_roles, wf_user_role_assignments).

Parameters & Filtering

Performance & Optimization

Similar to the R12 version, this report is generally performant but benefits from filtering in large environments.

FAQ

Q: Is RBAC fully supported in 11i? A: While R12 introduced more comprehensive UMX features, 11i uses Workflow roles heavily for business process routing and some access control. This report covers those Workflow role assignments.

© 2026 Enginatics