Script to Create  a New User from Backend and Add system Administrator Respnsibility in Oracle Apps R12.

DECLARE

v_user_name VARCHAR2 (100) := upper('&Enter_User_Name');

 v_description VARCHAR2 (100) := 'User';

BEGIN

 fnd_user_pkg.createuser

(x_user_name => v_user_name,

 x_owner => NULL,

 x_unencrypted_password => '&input_passwo',

 x_session_number => 0,

 x_start_date => SYSDATE,

 x_end_date => NULL,

 x_last_logon_date => NULL,

 x_description => v_description,

 x_password_date => NULL,

 x_password_accesses_left => NULL,

 x_password_lifespan_accesses => NULL,

 x_password_lifespan_days => NULL,

 x_employee_id => NULL,

 x_email_address => NULL,

 x_fax => NULL,

 x_customer_id => NULL,

 x_supplier_id => NULL,

 x_user_guid => NULL,

 x_change_source => NULL

 );

 COMMIT;

END;

 /

SHOW ERR;

/

select a.application_short_name, r.responsibility_key

from fnd_responsibility_vl r, fnd_application_vl a where

r.application_id =a.application_id

and upper(r.responsibility_name) like  upper ('%SYS%admi%');

/

DECLARE

 v_user_name VARCHAR2 (100) := upper('&1');

BEGIN

fnd_user_pkg.addresp(username => v_user_name

 ,resp_app => 'SYSADMIN' --SYSADMIN

 ,resp_key => 'SYSTEM_ADMINISTRATOR' --SYSTEM_ADMINISTRATOR

 ,security_group => 'STANDARD'

 ,description => NULL

 ,start_date => SYSDATE

 ,end_date => null);

 commit;

END;

 /

SHOW ERR;