FND User Upload  Help

FND User Upload creates and maintains Oracle E-Business Suite user accounts directly from Excel, together with their responsibility assignments. In a single template you can create new users, set or reset passwords, update contact details and validity dates, assign responsibilities (one per row), and optionally link a user to an existing employee or create the employee record at the same time. It is also a quick way to report on every user and the responsibilities they currently hold.

When to use it

• Onboard users in bulk – create many new EBS accounts in one pass.
• Assign responsibilities – grant or re-date responsibilities for new or existing users.
• Deactivate – end-date a user account or an individual responsibility assignment.
• Reset passwords in bulk, or update email, fax and descriptions across many accounts.
• Link to HR – tie a user to an existing person, or create the employee record alongside the account.
• Download and review all users and their active responsibilities without uploading any changes.

Before you start

• Blitz Report is installed and you are signed in to a responsibility that can administer EBS users and assign responsibilities (System Administrator level access).
• Any Responsibility, Application and Business Group you reference already exists – they are validated against their lists.
• To link or create an employee, Oracle HR is available and the Person / Employee Number resolves within the chosen Business Group.
• Any password you set meets your instance’s password policy.

Step 1 – Open the upload and choose a mode

Run FND User Upload from the Blitz Report menu and choose an Upload Mode:

• Create – an empty template for entering brand-new users.
• Create, Update – downloads existing users and their responsibility assignments so you can review or change them.

Whichever mode you pick, each row is automatically treated as a create or an update by checking whether the user already exists – you do not set an action yourself.

Step 2 – Set the parameters and download the template

In Create, Update mode the parameters limit what is downloaded:

Step 3 – Enter the user account

On each row enter the User Name and a User Start Date (both required). Optionally set a Password (the Unencrypted Password column – always blank on download; fill it only to set or change the password), a Description, Email Address, Fax, and a User End Date to deactivate the account.

Step 4 – Assign a responsibility

Each row carries the user plus one responsibility assignment: Responsibility Name, Responsibility Application and Responsibility Start (required), with an optional Responsibility End and assignment description. To grant several responsibilities to one user, repeat the user on several rows – one responsibility per row. Assignments are created as direct assignments in the Standard security group.

Step 5 – Link to an employee (optional)

To tie the account to a person, supply a Business Group and the Person or Employee Number. If no matching person exists, the upload creates a new employee from the First Name, Last Name, Gender, Date of Birth and email you provide. Leave Business Group blank for a plain, non-employee account.

Step 6 – Validate and Save

Click Validate and Save. This checks for missing required values and runs any extra validation the upload defines, then saves the file. Correct anything it flags before continuing.

Step 7 – Upload and view the result

Back in Blitz Report, click Upload and select your saved file. This submits the Blitz Upload request, which processes each row independently. When it finishes, a result report opens showing each row as success or error.

What’s produced

• New or updated user accounts, their direct responsibility assignments, and – where a Business Group was supplied – linked or newly created employee records.
• A result report listing every row with a status (success or error) and a message (for example “New user created.”, “Responsibility has been assigned to the user.” or “User has been updated.”), so you can see which rows succeeded and why any failed. The password column is always returned blank.

Common questions

How do I give one user several responsibilities?
Put the user on several rows – one responsibility per row. The account is touched once and each row adds or updates one assignment.

How do I set or reset a password?
Enter it in the Password column. It is never shown on download, and leaving it blank on an update keeps the existing password unchanged.

How do I deactivate a user or a responsibility?
Enter a User End Date to end-date the account, or a Responsibility End to end-date that one assignment. There is no separate delete action.

Do I have to fill in the employee fields?
No. They are used only when you supply a Business Group. Leave it blank to create or maintain a plain user account.

I’m in Create mode and the user already exists – what happens?
The user row is skipped (“Existing user, skipped user creation.”), but the responsibility on that row is still assigned if it is missing. Use Create, Update to change an existing user’s details.

Troubleshooting