Cloning R12: ORA-06502: PL/SQL: numeric or value error trying to update table fnd_profile_option_values (Doc ID 1501822.1)

Last updated on DECEMBER 24, 2015

Applies to:

Oracle Applications Manager - Version 12.0.0 to 12.1.3 [Release 12 to 12.1]
Information in this document applies to any platform.

Symptoms

Customer is cloning E-Business Suite R12, however process fails trying to configure the target system database server. Running perl adcfgclone.pl dbTier fails with following error found in ApplyDBTier log:

afdbprf.sh started at Mon Sep 10 10:58:59 CDT 2012


The environment settings are as follows ...

      .....

Executable : $ORACLE_HOME/bin/sqlplus


SQL*Plus: Release 11.2.0.3.0 Production on Mon Sep 10 10:58:59 2012

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

Enter value for 1: Enter value for 2: Enter value for 3: Connected.
[ FND_DB_WALLET_DIR ]
Application Id : 0
Profile Value  : $ORACLE_HOME/appsutil/wallet
Level Name: SITE
INFO       : Updated/created profile option value.
.
[ ECX_UTL_XSLT_DIR ]
Application Id : 174
Profile Value  : /usr/tmp
Level Name: SITE
INFO       : Updated/created profile option value.
.
[ ECX_UTL_LOG_DIR ]
Application Id : 174
Profile Value  : /usr/tmp
Level Name: SITE
INFO       : Updated/created profile option value.
.
[ BIS_DEBUG_LOG_DIRECTORY ]
Application Id : 0
Profile Value  : /usr/tmp
Level Name: SITE
INFO       : Updated/created profile option value.
.
begin
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "APPS.FND_PROFILE", line 731
ORA-06512: at "APPS.FND_PROFILE", line 963
ORA-06512: at "APPS.FND_PROFILE", line 3282
ORA-06512: at "APPS.ADX_PRF_PKG", line 203
ORA-06512: at line 33


Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ERRORCODE = 1 ERRORCODE_END
.end std out.

.end err out.

Changes

 Customer is cloning following cloning note 406982.1

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