Friday, 9 February 2018

ORA-04091: table APPLSYS.FND_PROFILE_OPTION_VALUES is mutating, trigger/function may not see it

ERROR:

Autoconfig failed with following error , checking on this

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'
ORA-06512: at line 43
ORA-06512: at line 123


Action Plan:

SQL> show user
USER is "APPS"


SQL> Alter TRIGGER APPS.ALR_FND_PROFILE_OPTIO_0_84_UAR disable;

Trigger altered.


>> adautoconfig completed successfully.

SQL> Alter TRIGGER APPS.ALR_FND_PROFILE_OPTIO_0_84_UAR enable;

Trigger altered.

No comments:

Post a Comment

OS Watcher Installation in RAC

 Step:1 Download and untar the oswbb812.tar under the grid user in RAC on the both nodes. Follow the OS Watcher User's Guide (Doc ID 153...