How to Change Password in Oracle Apps

How change apps password from front end?

Once you login into Oracle Goto--> Preferences.

In that you page you should be able to see the option to change the password.

How change apps password from back end?

Use the following anonymous block

declare


v_user_name varchar2(30):=upper('USER123');
v_new_password varchar2(30):='Pass55word';
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 reset successfully for the User:'||v_user_name);

commit;

else

DBMS_OUTPUT.put_line('Unable to reset password due to'||SQLCODE||' '||SUBSTR(SQLERRM, 1, 100));

rollback;

END

if;

end;