Autoconfig has failed with the below error in Oracle EBS R12.2 during the ADOP patching.
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 462
ORA-06512: at "APPS.FND_PROFILE", line 61
ORA-06512: at "APPS.ALR_FND_PROFILE_OPTIO_0_84_UAR", line 1
ORA-04088: error during execution of trigger
'APPS.ALR_FND_PROFILE_OPTIO_0_84_UAR'
ORA-06512: at line 43
ORA-06512: at line 109
Execute the below query to get the trigger 'ALR_FND_PROFILE_OPTIO_0_84_UAR' details
col owner for a20
col trigger_name for a30
col table_name for a30
set lines 300
SELECT OWNER,TRIGGER_NAME,STATUS,TABLE_NAME FROM DBA_TRIGGERS WHERE TABLE_NAME = 'FND_PROFILE_OPTION_VALUES' AND TABLE_OWNER = 'APPLSYS';
Disable the trigger and run Autoconfig
alter trigger APPS.ALR_FND_PROFILE_OPTIO_0_84_UAR DISABLE;
./adautocfg.sh
Enable the trigger once Autoconfig completes successfully
alter trigger APPS.ALR_FND_PROFILE_OPTIO_0_84_UAR ENABLE;
At last, below is the reason why it got failed.
ORA-04091: table APPLSYS.FND_PROFILE_OPTION_VALUES is mutating, trigger/function may not see it.
Cause: A trigger attempted to look at or modify a table that was in the middle of being modified by the statement which fired it and The APPLSYS.FND_PROFILE_OPTION_VALUES table is not designed for auditing and so when it is enabled it causes mutating and recursive actions for the table.
Comments