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.