The field PARAMETER.CONFIG could not be located or read

Problem Description:

When we login to apps it is not connecting but both database and apps are up and running.

Error :

"The field PARAMETER.CONFIG could not be located or read."
The adapcctl.log carries the following errors:
Cannot read value from field PARAMETER.CONFIG
Cause: The field PARAMETER.CONFIG could not be located or read.

Making AOL/J Test

ERROR:validateLogin returned false: failed to login as sysadmin, please try again.
AOLJ_JAVA_EXCEPTION (MESSAGE=Not able to create new database connection: FNDSECURITY_APPL_USERID_INVALID)
SECURITY_INVALID_DBC_PARAMETER (PARAMETER=GUEST_USER_PWD) (FILE=/progs/11i/prod/applmgr/prodappl/fnd/11.5.0/secure/prod_atlas/prod.dbc) (ROUTINE=AppsConnectionManager.makeGuestConnection)
FNDSECURITY_APPL_USERID_INVALID
SECURITY_APPL_USERID_INVALID
AOLJ_JAVA_EXCEPTION (MESSAGE=Profiles: getJDBCConnection() == null)
AOLJ_JAVA_EXCEPTION (MESSAGE=Not able to create new database connection: FNDSECURITY_APPL_USERID_INVALID)
SECURITY_INVALID_DBC_PARAMETER (PARAMETER=GUEST_USER_PWD) (FILE=/progs/11i/prod/applmgr/prodappl/fnd/11.5.0/secure/prod_atlas/prod.dbc) (ROUTINE=AppsConnectionManager.makeGuestConnection)
FNDSECURITY_APPL_USERID_INVALID
SECURITY_APPL_USERID_INVALID

Cause:

There is a problem with Guest user. So proceed checking Guest user.

Step 1 :

SQL> select fnd_web_sec.validate_login('GUEST','GUEST') from dual;
FND_WEB_SEC.VALIDATE_LOGIN('GUEST','GUEST')
--------------------------------------------------------------------------------
Y

SQL> select profile_option_value from fnd_profile_option_values where profile_option_id = 3805;
PROFILE_OPTION_VALUE
--------------------------------------------------------------------------------
GUEST/GUEST


Fix :

Check the FND_USER table and check the end_date column for the Guest user. It will be end dated. So to make it null do the following.

Login as apps user.

Back up your FND_USER TABLE

Run the following command

update fnd_user set end_date=null where user_name='GUEST';

Now Run the autoconfig.

Start Apps.