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