API to reset password in oracle apps

API to reset password in oracle apps

In this post , We will be discussing about API to reset password in oracle apps. This API helps to reset the user application password from backend in oracle apps. We can mass update the user application password with the help of this api in oracle apps. This is the standard API shared by oracle to reset password. We need to know the User Name to reset password using this API in oracle apps. Here below is the detail about API to reset password in oracle apps

API to reset password in oracle apps

Standard API to reset password in oracle apps

Here below is the package name uses to reset the password in oracle ebs

fnd_user_pkg.changepassword

PLSQL Script using API to reset password in oracle apps

DECLARE

     P_CHANGE BOOLEAN;

V_USER VARCHAR2(400):=’TEST_USER’;

V_NEW_PASSWORD VARCHAR2(400):=’P@1234’;

BEGIN

      P_CHANGE := fnd_user_pkg.changepassword(username=> V_USER

                                          ,newpassword => V_NEW_PASSWORD);

    IF P_CHANGE

     THEN

           DBMS_OUTPUT.PUT_LINE('Password has been successfully reset for user ‘||V_USER);

     ELSE

           DBMS_OUTPUT.PUT_LINE('Password reset has been failed for user ‘||V_USER);

     END IF;

END;

API to reset password in oracle apps

API for resetting password in oracle ebs