Reset Oracle EBS Application User Password through Oracle EBS API

Reset Oracle EBS Application User Password through Oracle EBS API


DECLARE
 flag_value BOOLEAN;
 BEGIN
 flag_value := fnd_user_pkg.changepassword(username=> 'NIZAM',newpassword => 'welcome1');
 IF flag_value
 THEN
 DBMS_OUTPUT.PUT_LINE('The password reset successfully');
 ELSE
 DBMS_OUTPUT.PUT_LINE('The password reset has failed');
 END IF;
 END;
 /
 COMMIT;