Thursday, June 4, 2009

APP-FND-01564: ORACLE error 1403 in changepassword

When we Try to change all schemas the Password using FNDCPASS, we had encountered the “SECURITY-UNABLE TO CONNECT TO SYSTEM “ error.
$ FNDCPASS apps/apps 0 Y system/manager ALLORACLE welcome

ERROR:

Related log file(L7187704.log) shows the Error message like below:
+---------------------------------------------------------------------------+
Application Object Library: Version : 12.0.0
Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
module:
+---------------------------------------------------------------------------+
Current system time is 04-MAY-2009 16:04:57
+---------------------------------------------------------------------------+
SECURITY-UNABLE TO CONNECT TO SYSTEM
APP-FND-01564: ORACLE error 1403 in changepassword
Cause: changepassword failed due to ORA-01403: no data found.

The SQL statement being executed at the time of the error was: and was executed from the file &ERRFILE.
+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 04-MAY-2009 16:04:57
+---------------------------------------------------------------------------+
Solution:
Recreating the grants & synonyms will solve the Issue with FNDCPASS

2 comments: