ORA-04091: Table APPLSYS.FND_PROFILE_OPTION_VALUES Is Mutating, Trigger/function May Not See It Error While Running ADOP Prepare Phase from Clone
(Doc ID 2481349.1)
Last updated on JANUARY 15, 2023
Applies to:Oracle Alert - Version 12.2.5 to 12.2.8 [Release 12.2]
Information in this document applies to any platform.
On : 12.2.5 version, Oracle Alert
Issue occurs when adop prepare is running in environment which is cloned from production.
Running an Oracle seeded trigger named "ALR_FND_PROFILE_OPTIO_0_84_UAR" owned by Oracle Alerts.
The following error is generated:
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'
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document