Wednesday, October 24, 2018

R12 Sysadmin account got locked after N number of invalid attempts

Run this query and make sure the account got locked

SELECT DECODE (encrypted_user_password
             , 'INVALID', 'Account locked'
             , 'Account not locked')
  FROM fnd_user
WHERE user_name = '&username';


We can't unlock the account as similar to dba_users account. Please use below command to reset the password.

FNDCPASS apps/XXXXXXX 0 Y system/XXXXXX USER SYSADMIN XXXXXXXX

No comments:

Post a Comment

How to Compile Forms , Reports & Custom.pll in R12.2

How to Compile Custom.pll   cd $AU_TOP/resource  cp CUSTOM.plx CUSTOM.plx_bkup  cp CUSTOM.pll CUSTOM.pll_bkup  frmcmp_batch module=CUSTOM.pl...