Scribd
Upload
48 views1 page

Reset Password API Implementation Guide

This API resets a user's password by calling the fnd_user_pkg.updateuserparty procedure, which updates the password for the user 'IBRAHIM' to 'bijoy1234' and sets it to expire in 500 days. Any exceptions are caught and the error code and message are output along with the current date and time.

Uploaded by

Muhammad Amir Hossain
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
48 views1 page

Reset Password API Implementation Guide

This API resets a user's password by calling the fnd_user_pkg.updateuserparty procedure, which updates the password for the user 'IBRAHIM' to 'bijoy1234' and sets it to expire in 500 days. Any exceptions are caught and the error code and message are output along with the current date and time.

Uploaded by

Muhammad Amir Hossain
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

API to Reset Password

DECLARE

v_code NUMBER;

v_errm VARCHAR2 (500);

BEGIN

fnd_user_pkg.updateuserparty (x_user_name => 'IBRAHIM',

x_owner => 'IBRAHIM',

x_unencrypted_password => 'bijoy1234',

x_password_date => SYSDATE + 500);

DBMS_OUTPUT.put_line ('Password Changed !!!! ');

COMMIT;

EXCEPTION

WHEN OTHERS

THEN

v_code := SQLCODE;

v_errm := SUBSTR (SQLERRM, 1, 500);

DBMS_OUTPUT.put_line ('Error code ' || v_code || ': ' || v_errm);

DBMS_OUTPUT.put_line ('Error time: ' || SYSDATE);

END;

You might also like