top of page

Autoconfig failed with ORA-04088: error during execution of trigger 'APPS.ALR_FND_PROFILE_OPTIO_0_84

Updated: Mar 24, 2023

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.

Recent Posts

See All

Comments


Contact Me

Tel: 7989359581

Lakshminarayana0071@gmail.com

  • Facebook Social Icon
  • LinkedIn Social Icon
  • Twitter Social Icon

Thanks for submitting!

© 2023 by Phil Steer . Proudly created with Wix.com

bottom of page