top of page
Search

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

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.

43 views0 comments

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