The field PARAMETER.CONFIG could not be located or read

Problem Description:
================


"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')
--------------------------------------------------------------------------------
N

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


SQL> select USER_NAME, END_DATE from fnd_user where USER_NAME like '%GUEST%'

USER_NAME END_DATE
------------------ --------------
GUEST 27/08/08
GUEST2
IBEGUEST


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';

Check Again below query, Now end date is null.

SQL> select USER_NAME, END_DATE from fnd_user where USER_NAME like '%GUEST%'

USER_NAME END_DATE
------------------ ---------------
GUEST
GUEST2
IBEGUEST

Now Run the autoconfig.

Start Apps.

2 comments:

Microsoft Office 2007 said...

NEVERTHELESS, THE CIVIL LAW is and must be neutral about who has a more noble or rewarding faith. The breakaway parishes ought to win every Office 2010facet of the lawsuit not becauseMicrosoft Office 2010 their beliefs or their politics are better, Microsoft wordbut because both lawOffice 2007and equity, along with common sense, are on Microsoft Officetheir side.Microsoft Office 2007 Not only does Virginia state law (the Division Statute)Office 2007 keyexplicitly apply to just such a Office 2007 downloadsituation as now exists, but the history Office 2007 Professionalespecially of The Falls Church argues against the claims of Outlook 2010the Virginia Diocese with which theyMicrosoft outlookhave disassociated.Microsoft outlook 2010First, The Falls Church wasWindows 7 founded, formed, and developed long before the diocese, or the national Episcopal Church, even existed.

Sridevi Koduru said...

Regards
Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, OAF, ADF, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.