7 Replies Latest reply on Nov 23, 2018 2:09 PM by Hari Sankar

    SYSADMIN ACCOUNTLOCKE

    Dr.Anty

      Hi,

       

      sysadmin Account locked.

      So please what the scenarios to resolve this issue....

       

      SQL> SELECT DECODE (encrypted_user_password , 'INVALID', 'Account locked', 'Account not locked')

        2   FROM fnd_user

        3  WHERE user_name = '&username';

      Enter value for username: SYSADMIN

      old   3: WHERE user_name = '&username'

      new   3: WHERE user_name = 'SYSADMIN'

       

      DECODE(ENCRYPTED_USER_PASSWORD,'INVALID','ACCOUNTLOCKE

      ------------------------------------------------------

      Account locked

       

       

      Regards,