DECLARE
l_ret_val BOOLEAN;
l_user_name varchar2(50) := '&USER_NAME';
l_new_pwd varchar2(20) := '&PASSWORD';
BEGIN
l_ret_val :=
fnd_user_pkg.changepassword(username=> l_user_name
,newpassword => l_new_pwd);
IF l_ret_val
THEN
DBMS_OUTPUT.PUT_LINE('The password is successfully reset to '|| l_new_pwd);
COMMIT;
ELSE
DBMS_OUTPUT.PUT_LINE('The password reset has failed');
END IF;
END;
It is not working in R12 version 12.2.3
ReplyDeleteworking
DeleteThis comment has been removed by the author.
ReplyDeleteIt worked for me in R12, thank you
ReplyDeleteThis comment has been removed by the author.
ReplyDeleteThanks
ReplyDeleteGood script
ReplyDeleteIs any way user can do themself like forgot password !!1
begin
Deletefnd_user_pkg.updateuser(
x_user_name => '&username'
, x_owner => 'CUST'
, x_unencrypted_password => '&new_password'
, x_password_date => to_date('2','J'));
commit;
end;
/