Best API to reset password in oracle EBS R12.

by

Introduction:-

In this article, we will use best API to reset 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.

API to reset 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

For another similar post for add/remove responsibility in EBS, click here.

Related to API , you may check the another URL.

Leave a Comment