FND User Upload – Oracle EBS SQL Report

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

Overview

Listing and updating all EBS users and their responsiblities

Report Parameters

Upload Mode, 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, per_all_people_f, per_business_groups, fnd_responsibility_vl, fnd_application, fnd_user_resp_groups_direct

Report Categories

Enginatics, Upload

FND Responsibility Access 11i, FND Responsibility Access, Blitz Report Assignments and Responsibilities, FND Responsibilities, FND Users, INV Item Upload, INV Items

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_Upload.xml
Full SQL on Enginatics www.enginatics.com/reports/fnd-user-upload/

Executive Summary

The FND User Upload report is a dual-purpose tool: it provides a detailed extract of user and responsibility data, and it is designed to facilitate mass updates or creation of users via the Blitz Report Upload functionality.

Business Challenge

Managing users in bulk is time-consuming. Tasks like “Create 50 new users for the training department” or “Add the ‘GL Inquiry’ responsibility to these 200 users” are tedious to perform manually in the Forms interface.

The Solution

This report extracts user data in a format that can be modified in Excel and then uploaded back into Oracle EBS (using the Blitz Report Upload framework). It streamlines:

Technical Architecture

The report queries fnd_user and fnd_user_resp_groups_direct. It is structured to align with the API parameters required for the user management APIs used by the upload process.

Parameters & Filtering

Performance & Optimization

The report is optimized for data extraction. When used for uploading, performance depends on the volume of records being processed by the API.

FAQ

Q: Can I reset passwords with this? A: Yes, if the upload template and API support password updates, this can be used for bulk password resets (usually to a temporary password).

Q: Does it validate the data? A: The upload process typically uses standard Oracle APIs which perform validation (e.g., checking if the responsibility name is valid).

© 2026 Enginatics