Tuesday, 23 May 2017

E-Business Autoconfig Issues/Autoconfig Issues seen after a Patch, Clone, Migration or Installation

While doing the cloning of Oracle Application and after that  run auto config, then getting the  following error occurs. 

ERROR
-----------------------
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 110
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 

Error Codes
---------------------------------------------------
ORA-04091,ORA-06512,ORA-04088

Solution:

Run the below query and check triggers status:

SELECT * FROM DBA_TRIGGERS WHERE TABLE_NAME = 'FND_PROFILE_OPTION_VALUES' AND TABLE_OWNER = 'APPLSYS';

If below trigger status enable then I suggested to disable the triggers and retest the issue.

ALR_FND_PROFILE_OPTIO_0_84_UAR
ALR_FND_PROFILE_OPTIO_0_84_IAR
-----------------------



No comments:

Post a Comment