How To Create New Users From Backend

The following Script can be used to create a User called ‘TESTUSER’ with Password as ‘WELCOME1’:

The Initial responsibility assigned in this case is System Administrator.

DECLARE
ln_user_id NUMBER;
ln_resp_id NUMBER;
ln_app_id NUMBER;

BEGIN
fnd_user_pkg.createUser( 'TESTUSER','','WELCOME1');

SELECT user_id
INTO ln_user_id
FROM fnd_user WHERE user_name = 'TESTUSER';

SELECT responsibility_id,
application_id
INTO ln_resp_id,
ln_app_id
FROM fnd_responsibility
WHERE responsibility_key = 'SYSTEM_ADMINISTRATOR';

FND_USER_RESP_GROUPS_API.insert_assignment( ln_user_id
,ln_resp_id
,ln_app_id
,NULL
,SYSDATE
,NULL
,NULL );

COMMIT;
END;