Wednesday, November 13, 2013

Unable to change USER password in R12


Error: Unable to change the password for fnd_user ASADMIN

[oracle@svruatebsal1 ~]$FNDCPASS apps/apps 0 Y system/manager USER ASADMIN oracle123
[oracle@svruatebsal1 ~]$ cat L9238207.log
+---------------------------------------------------------------------------+
Application Object Library: Version : 12.0.0
Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
 module:
+---------------------------------------------------------------------------+
Current system time is 14-NOV-2013 03:45:15
+---------------------------------------------------------------------------+

Working...
Unable to change the password for fnd_user ASADMIN.

+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 14-NOV-2013 03:45:15
+---------------------------------------------------------------------------+

SQL> select USER_NAME,ENCRYPTED_USER_PASSWORD,PASSWORD_LIFESPAN_DAYS from fnd_user where USER_NAME='ASADMIN';

SQL> select fnd_web_sec.validate_login('ASADMIN','<Password>') from dual;
FND_WEB_SEC.VALIDATE_LOGIN('ASADMIN','oracle123')
--------------------------------------------------------------------------------
N

solution
=========

Go to system Adminstrator---->profile--->system

query for profile option:Signon Password No Reuse

change 360 to 0    & save it.

[oracle@svruatebsal1 ~]$FNDCPASS apps/apps 0 Y system/manager USER ASADMIN oracle123
Note: cat the log file , it shows with out any error ...

SQL> select USER_NAME,ENCRYPTED_USER_PASSWORD,PASSWORD_LIFESPAN_DAYS from fnd_user where USER_NAME='ASADMIN';

SQL> select fnd_web_sec.validate_login('ASADMIN','<password>') from dual;

SQL> select fnd_web_sec.validate_login('ASADMIN','oracle123') from dual;

FND_WEB_SEC.VALIDATE_LOGIN('ASADMIN','ORACLE123')
--------------------------------------------------------------------------------
Y

Go to system Adminstrator---->profile--->system

query for profile option:Signon Password No Reuse

change 0 to 360    & save it.


+++++++++++++++++++++++++++++++++

No comments:

Post a Comment