Tuesday, October 22, 2013

Changing Password for an Oracle Applications 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:

Post a Comment

Best Blogger TipsGet Flower Effect