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

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

Solution

1) Run following query to determine profile_option_id associated with profile_option_name = 'UTL_FILE_LOG':

select profile_option_id,

profile_option_name

from fnd_profile_options

where profile_option_name = 'UTL_FILE_LOG';

2) Run following query to determine profile_option_value based on retrieved profile_option_id:

select profile_option_id,

profile_option_value,

application_id,

level_id,

level_value

from fnd_profile_option_values

where profile_option_id = <value from query 1>;

3) Manually update the profile option in table fnd_profile_option_values to be just /usr/tmp:

update fnd_profile_option_values

set profile_option_value = '/usr/tmp'

where profile_option_id=<value from query 1>;

4) Rerun perl adcfgclone.pl dbTier.