API to reset password in oracle apps

Reset Oracle apps password from backend | Being Oracle Database administrator,we are using various API scripts to do the administrative task in Oracle Database.Before executing script we should test it on test/dev instance, then migrate the solution/script to production carefully. Here we are discussing 'how to change user password in oracle apps from backend' using API.

----------------------------------------------------------------
-----------reset oracle apps password from backend
----------------------------------------------------------------

DECLARE
    lb_status BOOLEAN;
BEGIN
    lb_status := FND_USER_PKG.CHANGEPASSWORD
                                                            (
                                                                username           => '&Username',
                                                                newpassword     => '&NewPassword'
                                                           );

    IF lb_status
    THEN
        DBMS_OUTPUT.PUT_LINE('Request processed sucessfully');
    ELSE
        DBMS_OUTPUT.PUT_LINE('Error while processing the request');
    END IF;
END;
/
exit;


copy above API code to 'reset password in oracle apps r12'. You can make script to reset the password.

$vi resetpwd.sql

-->paste here and save it

:wq!

$sqlplus apps/apps

$SQL>@resetpwd.sql