Reset Password from Backend in Oracle Apps

DECLARE
v_chr_user_name fnd_user.user_name%TYPE := UPPER (‘&Enter_User_Name’);
v_chr_new_password VARCHAR2 (30) := ‘&Enter_New_Password’;
v_boo_status BOOLEAN;
BEGIN
v_boo_status :=
fnd_user_pkg.ChangePassword (username => v_chr_user_name,
newpassword => v_chr_new_password);

IF v_boo_status = TRUE
THEN
DBMS_OUTPUT.put_line (
‘Password Reset Successful for ‘ || v_chr_user_name);
COMMIT;
ELSE
DBMS_OUTPUT.put_line (
‘Failed to Reset Password’ || SQLCODE || ‘ ‘ || SQLERRM);
END IF;
END;

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s