1 Reply Latest reply on Aug 1, 2019 6:24 AM by MihaiF

    Oracle EBS Unlock User account from security forms

    3632554

      Dear All,

       

      Could you advise me, how can unlock User account (for Oracle EBS user ) from security forms, or using database command?

       

       

      Regards

        • 1. Re: Oracle EBS Unlock User account from security forms
          MihaiF

          Hi

           

          There is a quick way of unlocking your user account again by reassigning a new password to your own username through code. You must have the correct permissions when connecting to the database so if you have for example the APPS credentials than you're good to go.

           

          Connect with the EBS database using the APPS user and run the below code snippet to Unlock the user account. Of course change the values of the parameters username and new password to fit your needs.

           

          DECLARE

              status BOOLEAN;

          BEGIN

              status := FND_USER_PKG.CHANGEPASSWORD(username => '<your username>',

                                                    newpassword => 'welcome123');


              IF status

              THEN

                  DBMS_OUTPUT.PUT_LINE('Password changed and user unlocked');

                  commit;

              ELSE

                  DBMS_OUTPUT.PUT_LINE('Error while setting password');

              END IF;

          END;

           

           

           

          Thanks,

          MihaiF