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 DECEMBER 05, 2018

Applies to:

Oracle Alert - Version 12.2.5 to 12.2.8 [Release 12.2]
Information in this document applies to any platform.

Symptoms

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



Changes

 

Cause

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
Symptoms
Changes
Cause
Solution


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