My Oracle Support Banner

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

Last updated on DECEMBER 05, 2019

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>


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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.