Friday, August 17, 2018

How to create Oracle Apps User from Backend?

DECLARE
v_user_name VARCHAR2 (100) := 'GTEST';
v_Email VARCHAR2(100):='giridhar.t22@gmail.com';
BEGIN
 fnd_user_pkg.createuser
(x_user_name => v_user_name,
 x_owner => NULL,
 x_unencrypted_password => 'Welcome123',
 x_session_number => 0,
 x_start_date => SYSDATE,
 x_end_date => NULL,
 x_last_logon_date => NULL,
 x_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 => v_email,
 x_fax => NULL,
 x_customer_id => NULL,
 x_supplier_id => NULL,
 x_user_guid => NULL,
 x_change_source => NULL
 );
 
 fnd_user_pkg.addresp(username => v_user_name
 ,resp_app => 'SYSADMIN'
 ,resp_key => 'SYSTEM_ADMINISTRATOR'
 ,security_group => 'STANDARD'
 ,description => NULL
 ,start_date => SYSDATE
 ,end_date => null);

 COMMIT;
END;

No comments:

Post a Comment