| layout | default |
|---|---|
| title | FND User Upload | Oracle EBS SQL Report |
| description | Listing and updating all EBS users and their responsiblities – Oracle E-Business Suite SQL report |
| keywords | Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, Upload, FND, User, fnd_user, per_all_people_f, per_business_groups |
| permalink | /FND%20User%20Upload/ |
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Listing and updating all EBS users and their responsiblities
Upload Mode, User Name, Has Access to Responsibility, Has Access to Application, Active only, Creation Date From, Creation Date To, Created within days
fnd_user, per_all_people_f, per_business_groups, fnd_responsibility_vl, fnd_application, fnd_user_resp_groups_direct
FND Responsibility Access 11i, FND Responsibility Access, Blitz Report Assignments and Responsibilities, FND Responsibilities, FND Users, INV Item Upload, INV Items
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.
| 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/ |
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.
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.
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:
- Mass user creation.
- Mass assignment of responsibilities.
- Updating user attributes (email, description, etc.).
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.
- Upload Mode: Controls the behavior of the upload (e.g., Create, Update).
- User Name: Filter for specific users to extract/update.
- Has Access to Responsibility: Find users with a specific responsibility (useful for cloning access).
The report is optimized for data extraction. When used for uploading, performance depends on the volume of records being processed by the API.
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).
- Blitz Report™ – World’s Fastest Oracle EBS Reporting Tool
- Oracle Discoverer Replacement – Import Worksheets into Blitz Report™
- Oracle EBS Reporting Toolkits by Blitz Report™
- Blitz Report™ FAQ & Community Q&A
- Supply Chain Hub by Blitz Report™
- Blitz Report™ Customer Case Studies
- Oracle EBS Reporting Blog
- Oracle EBS Reporting Resource Centre
© 2026 Enginatics