AutoConfig Fails On Applications Tier In R12.2.0 EBS (Doc ID 1912332.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Applications Manager - Version 12.2 to 12.2 [Release 12.2]
Information in this document applies to any platform.

Symptoms

On E-Business Suite (EBS) 12.2 version, Other OAM features
when attempting to run autoconfig on the apps tier,
the following error occurs:

Executing script in InstantiateFile:
/oard/oracle/oardappl/fs1/FMW_Home/webtier/perl/bin/perl -I /oard/oracle/oardappl/fs1/FMW_Home/webtier/perl/lib/5.10.0 -I /oard/oracle/oardappl/fs1/FMW_Home/webtier/perl/lib/site_perl/5.10.0 -I /oard/oracle/oardappl/fs1/EBSapps/appl/au/12.0.0/perl -I /oard/oracle/oardappl/fs1/FMW_Home/webtier/ohs/mod_perl/lib/site_perl/5.10.0/x86_64-linux-thread-multi /oard/oracle/oardappl/fs1/inst/apps/OARD_oacmrd/admin/scripts/adexecsql.pl sqlfile=/oard/oracle/oardappl/fs1/inst/apps/OARD_oacmrd/admin/install/afwebprf.sql
script returned:
****************************************************

adexecsql.pl started at Mon, 07 Jul 2014 10:51:04 -0400

File System type : run

The environment settings are as follows ...

  ORACLE_HOME : /oard/oracle/oardappl/fs1/EBSapps/10.1.2
  TWO_TASK : OARD
  PATH : /oard/oracle/oardappl/fs1/EBSapps/10.1.2/bin:/usr/bin:/usr/sbin:/oard/oracle/oardappl/fs1/EBSapps/comn/util/jdk32/jre/bin:$PATH:/oard/oracle/oardappl/fs1/FMW_Home/webtier/perl/bin:/oard/oracle/oardappl/fs_ne/EBSapps/appl/ad/bin:/oard/oracle/oardappl/fs1/FMW_Home/modules/org.apache.ant_1.7.1/bin:/oard/oracle/oardappl/fs1/inst/apps/OARD_oacmrd/admin/scripts:/oard/oracle/oardappl/fs1/FMW_Home/webtier/perl/bin:/oard/oracle/oardappl/fs1/EBSapps/10.1.2/bin:/oard/oracle/oardappl/fs1/EBSapps/appl/fnd/12.0.0/bin:/oard/oracle/oardappl/fs1/EBSapps/appl/ad/12.0.0/bin:/oard/oracle/oardappl/fs1/EBSapps/comn/util/jdk32/jre/bin:/oard/oracle/oardappl/fs1/EBSapps/comn/util/jdk32/bin::/oard/oracle/oardappl/fs1/EBSapps/10.1.2/OPatch:/oard/oracle/oardappl/fs1/EBSapps/10.1.2/bin:/usr/bin:/usr/sbin:/oard/oracle/oardappl/fs1/EBSapps/comn/util/jdk32/jre/bin:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/apploard/bin
  TNS_ADMIN : /oard/oracle/oardappl/fs1/inst/apps/OARD_oacmrd/ora/10.1.2/network/admin
  LD_LIBRARY_PATH : /oard/oracle/oardappl/fs1/EBSapps/10.1.2/lib32:/oard/oracle/oardappl/fs1/EBSapps/10.1.2/lib:/usr/X11R6/lib:/usr/openwin/lib:/oard/oracle/oardappl/fs1/EBSapps/10.1.2/jdk/jre/lib/i386:/oard/oracle/oardappl/fs1/EBSapps/10.1.2/jdk/jre/lib/i386/server:/oard/oracle/oardappl/fs1/EBSapps/10.1.2/jdk/jre/lib/i386/native_threads:/oard/oracle/oardappl/fs1/EBSapps/appl/sht/12.0.0/lib

SQLPLUS Executable : /oard/oracle/oardappl/fs1/EBSapps/10.1.2/bin/sqlplus


SQL*Plus: Release 10.1.0.5.0 - Production on Mon Jul 28 10:51:05 2014

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Enter value for 1: Enter value for 2: Enter value for 3: Connected.
[ APPS_WEB_AGENT ]
Application Id : 0
Profile Value : http://test.com:8080/pls/OARD
Level Name: SITE
INFO : Updated/created profile option value.
.
Deleted : 0
[ APPS_SERVLET_AGENT ]
Application Id : 0
Profile Value : http://test.com:8080/OA_HTML
Level Name: SITE
INFO : Updated/created profile option value.
.
Deleted : 0
[ APPS_JSP_AGENT ]
Application Id : 0
Profile Value : http://test.com:8080
Level Name: SITE
INFO : Updated/created profile option value.
.
Deleted : 0
[ APPS_FRAMEWORK_AGENT ]
Application Id : 0
Profile Value : http://test.com:8080
Level Name: SITE
INFO : Updated/created profile option value.
.
Deleted : 0
[ WF_MAIL_WEB_AGENT ]
Application Id : 0
Profile Value :
Level Name: SITE
INFO : Updated/created profile option value.
.
[ HELP_WEB_AGENT ]
Application Id : 0
Profile Value :
Level Name: SITE
INFO : Updated/created profile option value.
.
Deleted : 0
[ HELP_WEB_BASE_URL ]
Application Id : 0
Profile Value : http://test.com:8080/OA_HTML/
Level Name: SITE
INFO : Updated/created profile option value.
.
declare
*
ERROR at line 1:
ORA-00904: "LEVEL_VALUE2": invalid identifier
ORA-06512: at "APPS.ADX_PRF_PKG", line 207
ORA-06512: at line 288


Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Error encountered while running /oard/oracle/oardappl/fs1/inst/apps/OARD_oacmrd/admin/install/afwebprf.sql
ERRORCODE = 1 ERRORCODE_END
.end std out.

.end err out.
****************************************************



The issue can be reproduced at will with the following steps:
1. Run autoconfig on the Applications tier.

The issue has the following business impact:
Due to this issue, users cannot perform the 12.2.3 upgrade

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms