Introduction
This blog explains how to create user and add responsibility for a user from the backend.
#Code#
DECLARE
lc_user_name VARCHAR2(100) := RAJAN_TEST’;
lc_user_password VARCHAR2(100) := ‘Oracle123′;
ld_user_start_date DATE := TO_DATE(’23-JUN-2012′);
ld_user_end_date VARCHAR2(100) := NULL;
ld_password_date VARCHAR2(100) := TO_DATE(’23-JUN-2012’);
ld_password_lifespan_days NUMBER := 90;
ln_person_id NUMBER := 32979;
lc_email_address VARCHAR2(100) := ‘RAJAN_TEST@doyensys.com’;
BEGIN
fnd_user_pkg.createuser
( x_user_name => lc_user_name,
x_owner => NULL,
x_unencrypted_password => lc_user_password,
x_start_date => ld_user_start_date,
x_end_date => ld_user_end_date,
x_password_date => ld_password_date,
x_password_lifespan_days => ld_password_lifespan_days,
x_employee_id => ln_person_id,
x_email_address => lc_email_address
);
COMMIT;
EXCEPTION
WHEN OTHERS THEN
ROLLBACK;
DBMS_OUTPUT.PUT_LINE(SQLERRM);
END;
/
DECLARE
lc_user_name VARCHAR2(100) := RAJAN_TEST’;
lc_resp_appl_short_name VARCHAR2(100) := ‘FND’;
lc_responsibility_key VARCHAR2(100) := ‘APPLICATION_DEVELOPER’;
lc_security_group_key VARCHAR2(100) := ‘STANDARD’;
ld_resp_start_date DATE := TO_DATE(’25-JUN-2019′);
ld_resp_end_date DATE := NULL;
BEGIN
fnd_user_pkg.addresp
( username => lc_user_name,
resp_app => lc_resp_appl_short_name,
resp_key => lc_responsibility_key,
security_group => lc_security_group_key,
description => NULL,
start_date => ld_resp_start_date,
end_date => ld_resp_end_date
);
COMMIT;
EXCEPTION
WHEN OTHERS THEN
ROLLBACK;
DBMS_OUTPUT.PUT_LINE(SQLERRM);
END;
/
Conclusion
This query will be useful for enabling and resetting the password
