1) API to create FND User<\/p>\n
2) API to add responsibilities to a user 3) API to remove responsibilities from a user 4) API to change pasword<\/p>\n declare 1) API to create FND User BEGIN fnd_user_pkg.CreateUser ( x_user_name => ‘Operations’, x_owner => NULL, x_unencrypted_password =>’welcome1′, x_start_date => TO_DATE(’01-JAN-2000′), x_end_date => NULL, x_last_logon_date => NULL, x_description => ‘Operations User’, x_password_date => NULL, x_password_accesses_left => NULL, x_employee_id => NULL, x_email_address => NULL, x_fax => NULL, x_customer_id => NULL, x_supplier_id => NULL); COMMIT; END; 2) API […]<\/p>\n","protected":false},"author":17,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[500],"tags":[146,530,147,134,135],"class_list":["post-4260","post","type-post","status-publish","format-standard","hentry","category-sysadmin-api","tag-add","tag-api","tag-remove","tag-responsibilities","tag-users"],"yoast_head":"\nBEGIN
\nfnd_user_pkg.CreateUser ( x_user_name => 'Operations',
\nx_owner => NULL,
\nx_unencrypted_password =>'welcome1',
\nx_start_date => TO_DATE('01-JAN-2000'),
\nx_end_date => NULL, x_last_logon_date => NULL,
\nx_description => 'Operations User',
\nx_password_date => NULL,
\nx_password_accesses_left => NULL,
\nx_employee_id => NULL,
\nx_email_address => NULL,
\nx_fax => NULL,
\nx_customer_id => NULL,
\nx_supplier_id => NULL);
\nCOMMIT;
\nEND;<\/code><\/p>\n
\nBEGIN
\nfnd_user_pkg.addresp(username => 'ABC',
\nresp_app => 'SYSADMIN',
\nresp_key => 'SYSTEM_ADMINISTRATOR',
\nsecurity_group => 'STANDARD',
\ndescription => NULL,
\nstart_date => TO_DATE('01-JAN-2000'),
\nend_date => NULL );
\nCOMMIT;
\nEND;<\/code><\/p>\n
\n–This script will end date the assignment of responsibility to user
\nBEGIN
\nfnd_user_pkg.delresp(username => 'ABC',
\nresp_app => 'SYSADMIN',
\nresp_key => 'SYSTEM_ADMINISTRATOR',
\nsecurity_group => 'STANDARD' );
\nCOMMIT;
\nEND;<\/code><\/p>\n
\nv_user_name varchar2(30):=upper(‘&Enter_User_Name’);
\nv_new_password varchar2(30):=’&Enter_New_Password’;
\nv_status boolean;
\nbegin
\nv_status:= fnd_user_pkg.ChangePassword (
\nusername => v_user_name,
\nnewpassword => v_new_password
\n);
\nif v_status =true then
\ndbms_output.put_line (‘The password reset successfully for the User:’||v_user_name);
\ncommit;
\nelse
\nDBMS_OUTPUT.put_line (‘Unable to reset password due to’||SQLCODE||’ ‘||SUBSTR(SQLERRM, 1, 100));
\nrollback;
\nEND if;
\nend;<\/p>\n","protected":false},"excerpt":{"rendered":"