Autoconfig error

Posted by satish on Aug 10, 2020; 12:46am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Autoconfig-error-tp8605.html

Dear Erman,

While running autoconfig in apps tier in R12.1.3 after clone,We faced below error.

==
Error
======

igccmprf.sh             INSTE8_PRF         1
okladmprf.sh            INSTE8_PRF         1
AutoConfig is exiting with status 2
Enter value for 1: Enter value for 2: Enter value for 3: Connected.
declare
*
ERROR at line 1:

ORA-04091: table APPLSYS.FND_PROFILE_OPTION_VALUES is mutating,
trigger/function may not see it
ORA-06512: at "APPS.FND_CORE_LOG", line 45
ORA-06512: at "APPS.FND_CORE_LOG", line 456
ORA-06512: at "APPS.FND_PROFILE", line 122
ORA-06512: at "APPS.ALR_FND_PROFILE_OPTIO_0_84_UAR", line 2
ORA-04088: error during execution of trigger
'APPS.ALR_FND_PROFILE_OPTIO_0_84_UAR'


We fixed it by disabling the trigger,rerun autoconfig and enable it again.But what is the reason for this error?I didnt find any thing on internet or in MOS notes.

Thank Yoiu