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

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

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

AP Suppliers, FND Responsibility Access, FND Responsibilities, INV Items, FND Users, INV Item Upload, INV Item Upload 11i

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 Example
Blitz Report™ XML Import FND_User_Upload.xml
SQL Source FND User Upload.sql
Full Report 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).

© Enginatics GmbH