FNDSECURITY_APPL_LOGIN_FAILED

LOG Jserv

========

oracle.apps.jtf.base.resources.FrameworkException: oracle.apps.fnd.common.PoolException: Not able to create new database connection: FNDSECURITY_APPL_LOGIN_FAILED

Start aplikasi

==========

Unable to update GUEST_USER_PWD in database to GUEST/NEWPASS - Cannot access application ORACLE password

Cause: Application Object Library was unable access your ORACLE password.

Action: Contact your support representative.
Unable to update GUEST_USER_PWD in database to GUEST/NEWPASS - Cannot access application ORACLE password.

FNDCPASS

=========

bash-4.1$ more L371647.log

+---------------------------------------------------------------------------+

Application Object Library: Version : 11.5.0

Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

 module:

+---------------------------------------------------------------------------+

Current system time is 31-JAN-2013 09:41:29

+---------------------------------------------------------------------------+

Working...

FNDCPASS was not able to decrypt password for GUEST during applsys password change. 

+---------------------------------------------------------------------------+

Concurrent request completed successfully

Current system time is 31-JAN-2013 09:41:35

+---------------------------------------------------------------------------+

Solution

·         export table FND_USER dan FND_ORACLE_USERID dari production.

·         create user temporary

·         import FND_USER dan FND_ORACLE_USERID ke user temporary

·         backup FND_USER dan FND_ORACLE_USERID

·         create table applsys.fnd_user_bkp as select * from applsys.fnd_user;

·         create table applsys.fnd_oracle_userid_bkp as select * from applsys.fnd_oracle_userid;

·         delete fnd_user;

·         delete fnd_oracleuser_id;

·         insert into applsys.fnd_user (select * from temporary.fnd_user);

·         insert into applsys.fnd_oracle_userid (select * from temporary.fnd_oracle_userid);

·         commit;

·         alter user applsys identified by <password prod>

·         alter user apps identified by <password prod>

·         bounce aplikasi

·         test halaman login