My Oracle Support Banner

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.