creating a user in Oracle E-Business Suite (EBS) R12 and assigning system responsibilities.

 Creating a user in Oracle E-Business Suite (EBS) R12 and assigning system responsibilities.

Step 1: Log in to Oracle EBS

1. Open a web browser and go to the Oracle EBS login page.
2. Enter your Username and Password.
3. Click Login.

---

Step 2: Navigate to User Management

1. Go to System Administrator responsibility.
2. Navigate to:
   Security → User → Define

---

Step 3: Create a New User

1. In the Users form, enter the following details:

   • User Name: (e.g., JOHNDOE)
   • Password: (Enter a temporary password; the user will change it on first login)
   • Description: (Optional, e.g., "Finance Team User")
   • Person: (If linked to an employee, click the LOV to select)
   • Customer/Supplier: (If applicable, choose the respective entity)
   • Email: (For notifications)
   • Effective Dates:
     • From: (Set to today’s date)
     • To: (Leave blank if the account is permanent)

2. Save the record (Ctrl + S or click the disk icon).

---

Step 4: Assign Responsibilities

1. In the same Users form, navigate to the Responsibilities block.
2. Click in the Responsibility Name field and enter the responsibility (use F11 to search if needed).
   • Examples:
     • System Administrator
     • Application Developer
     • General Ledger Super User
3. Save the record.

---

Step 5: Verify the User Account

1. Run the following SQL query in the database to verify the user:

   
   SELECT user_id, user_name, start_date, end_date 
   FROM fnd_user 
   WHERE user_name = 'JOHNDOE';
   

2. Check assigned responsibilities:

   
   SELECT fu.user_name, fr.responsibility_name
   FROM fnd_user fu
   JOIN fnd_user_resp_groups_direct frg ON fu.user_id = frg.user_id
   JOIN fnd_responsibility fr ON frg.responsibility_id = fr.responsibility_id
   WHERE fu.user_name = 'JOHNDOE';
   

---

Step 6: Inform the User

• Share the Username and Temporary Password with the user.
• Instruct them to log in and change the password at first login.

---

Step 7: Optional - Set Profile Options (If Needed)

To set profile options for the user:

1. Navigate to:
   System Administrator → Profile → System
2. Query the user and assign any required profile options (e.g., MO: Operating Unit).

---

Step 8: Validate Login and Responsibility Access

• The user should log in and verify they can access the assigned responsibilities.
• If any access issues arise, recheck responsibility assignments.

---

Troubleshooting

• If a user cannot log in:
  • Check if their account is Active (end_date should be NULL).
  • Reset their password in User Management.
  • Check for security rules restricting access.