How to change user password in oracle apps from backend

How to change user password in oracle apps from backend

In this post , We will discuss about How to change user password in oracle apps from backend. User related information's stores in the FND_USER table. We often need Requirment during development to change the multiple passwords in oracle apps so for developer backend is the best option so here I will share the sample script to change user password in oracle apps from backend.

 

 

How to change user password in oracle apps from backend

 

declare
 v_user_name varchar2(30):=upper(:P_USER_NAME);
 v_new_password varchar2(30):=:P_USER_PASSWORD;
 v_status boolean;
 begin
 v_status:= fnd_user_pkg.ChangePassword (
 username => v_user_name,
 newpassword => v_new_password
 );

 if v_status =true then
 dbms_output.put_line ('The password has been changed for :'||v_user_name);
 commit;
 else
 DBMS_OUTPUT.put_line ('Unable to reset password due to'||SQLCODE||' '||SUBSTR(SQLERRM, 1, 100));
 rollback;
 END if;
 end;