Autoconfig error

[satish]

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

[ErmanArslansOracleBlog]

Did you enable audit on APPLSYS.FND_PROFILE_OPTION_VALUES table?

This occurs when auditing is setup on the table.
 
That table is not designed for auditing. So when enabled, it causes mutating and recursive actions for the table.