AutoConfig Fails On Applications Tier In R12.2.0 EBS
(Doc ID 1912332.1)
Last updated on MAY 16, 2024
Applies to:
Oracle Applications Manager - Version 12.2 to 12.2 [Release 12.2Cloud]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:
..../afwebprf.sql
script returned:
****************************************************
adexecsql.pl started at <timestamp>
..../afwebprf.sql
script returned:
****************************************************
adexecsql.pl started at <timestamp>
File System type : run
The environment settings are as follows ...
ORACLE_HOME : <10.1.2_ORACLE_HOME>
...
SQLPLUS Executable : <10.1.2_ORACLE_HOME>/bin/sqlplus
..
Enter value for 1: Enter value for 2: Enter value for 3: Connected.
[ APPS_WEB_AGENT ]
Application Id : 0
Profile Value : http://<host.domain>:<port>/<...>/TEST
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
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Error encountered while running $INST_TOP/apps/<SID>_<host>/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
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |