Chitika Add

Friday, December 13

Changing Password for an Oracle User in R12 Oracle Apps using API

-- FND_USER_PKG.CHANGEPASSWORD

/*This article helps in changing the password for Oracle USER using API FND_USER_PKG.CHANGEPASSWORD.

This API is tested in R12.1.3*/

DECLARE
   v_user_name      VARCHAR2 (100) := 'OPERATIONS';

   v_new_password   VARCHAR2 (100) := :NEWPASSWORD;

   v_status         BOOLEAN := NULL;
BEGIN
   v_status := fnd_user_pkg.changepassword (v_user_name, v_new_password);

   COMMIT;



   DBMS_OUTPUT.
    put_line (
      'Password is changed successfully for the user ' || v_user_name);
EXCEPTION
   WHEN OTHERS
   THEN
      DBMS_OUTPUT.
       put_line (
         'Error encountered while setting new password to the user and the error is '
         || SQLERRM);
END;

No comments: