Sunday, March 18, 2018

API to update Oracle Application User Password (fnd_user_pkg.ChangePassword)











In this post, we have shared a script to update the password of Oracle Application User. 


API: fnd_user_pkg.ChangePassword

Script:

SET SERVEROUTPUT ON;

DECLARE
  lb_result BOOLEAN;
BEGIN
  lb_result := fnd_user_pkg.ChangePassword(username    => 'SYSADMIN',
                                           newpassword => 'dba#1234'
                                          );
  IF lb_result
  THEN
    DBMS_OUTPUT.PUT_LINE('Sucessfully Updated');
  END IF;
END;

Hope this helps!!

 

0 Responses to “API to update Oracle Application User Password (fnd_user_pkg.ChangePassword)”

Post a Comment

Disclaimer

The ideas, thoughts and concepts expressed here are my own. They, in no way reflect those of my employer or any other organization/client that I am associated. The articles presented doesn't imply to any particular organization or client and are meant only for knowledge Sharing purpose. The articles can't be reproduced or copied without the Owner's knowledge or permission.