How to create an FND User and add responsibility to it from Front and back end.

Create an Oracle apps FND user and add responsibility from front end!

1.  Login to apps and navigate to System Administrator > Security  > User > Define.

2.   Enter Username, As per User Number 

3.   Password: Fill the password and press Enter then type again same password.

4   Responsibility: Select Responsibility from LOV whatever you want to Assign to user.

Create an Oracle FND user within seconds from Back end!

Use the below script to create an E-Business Suite user in less than a second's time via backend.
This script uses the oracle package.procedure fnd_user_pkg.createuser to create a new user.

DECLARE
   v_user_name    VARCHAR2 (30) := UPPER ('&Enter_User_Name');
   v_password     VARCHAR2 (30) := '&Enter_Password';
   v_session_id   INTEGER := USERENV ('sessionid');
   v_email        VARCHAR2 (30) := UPPER ('&Enter_Email_Id');
BEGIN
   fnd_user_pkg.createuser (x_user_name       => v_user_name,
                            x_owner                            => NULL,
                            x_unencrypted_password   => v_password,
                            x_session_number             => v_session_id,
                            x_start_date                       => SYSDATE,
                            x_end_date                        => NULL,
                            x_email_address                => v_email);
   COMMIT;
   DBMS_OUTPUT.put_line ('User:' || v_user_name || 'Created Successfully');
EXCEPTION
   WHEN OTHERS
   THEN
      DBMS_OUTPUT.put_line (
            'Unable to create User due to'
         || SQLCODE
         || ' '
         || SUBSTR (SQLERRM, 1, 100));
      ROLLBACK;
END;

Add responsibility to the user created :-

BEGIN

FND_USER_PKG.ADDRESP(
                      USERNAME               => 'MYUSER',

                      RESP_APP                 => 'SYSADMIN',

                      RESP_KEY                 => 'SYSTEM_ADMINISTRATOR',

                      SECURITY_GROUP  => 'STANDARD',

                      DESCRIPTION           => NULL,

                      START_DATE            => TRUNC(SYSDATE),

                      END_DATE               => NULL); 

COMMIT;

END;

Attention!! After user creation when you log in with the new user first time You will be asked to change the password. Change the password and enjoy learning oracle apps.

Check if the user was created:
Select * from fnd_user where user_name like 'TRICK%'