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.
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