Saturday, October 18, 2014

Create User and add Responsibilities

1) API to create FND User

BEGIN

fnd_user_pkg.CreateUser ( v_user_name => 'HRMS',
v_owner => NULL,
v_unencrypted_password =>'SHAHANI',
v_start_date => TO_DATE('01-JAN-2014'),
v_end_date => NULL,
v_last_logon_date => NULL,
v_description => 'HRMS User',
v_password_date => NULL,
v_password_accesses_left => NULL,
v_employee_id => NULL,
v_email_address => NULL,
v_fax => NULL,
v_customer_id => NULL,
v_supplier_id => NULL
);

COMMIT;

END;


2) API to add responsibilities to a user

BEGIN

fnd_user_pkg.addresp(username => 'HRMS',
resp_app => 'SYSADMIN',
resp_key => 'SYSTEM_ADMINISTRATOR',
security_group => 'STANDARD',
description => NULL,
start_date => TO_DATE('01-JAN-2014'),
end_date => NULL );

COMMIT;

END;