api for resetting password in oracle ebs

api for resetting password in oracle ebs

In this post , We will be discussing about api for resetting password in oracle ebs. This API helps to reset the user account password from backend in oracle abs. We can mass update the user account password with the help of this api in oracle EBS. This is the standard API shared by oracle for resetting password. We need to know the User Name for resetting password using API. Here below is the complete script using api for resetting password in oracle ebs.

Standard API for resetting password in oracle ebs

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

fnd_user_pkg.changepassword

PLSQL Script for resetting password in oracle ebs

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 for resetting password in oracle ebs