Home » Applications » Oracle Fusion Apps & E-Business Suite » Mutating error for FND_PROFILE_OPTION_VALUES
Mutating error for FND_PROFILE_OPTION_VALUES [message #242343] Fri, 01 June 2007 11:08
vz86mj
Messages: 6
Registered: May 2007
Junior Member
Hi,

I am using the following code in new DEV env to update:

update fnd_profile_option_values
set profile_option_value = p_profile_value
where (application_id, profile_option_id) in (
select application_id, profile_option_id
from fnd_profile_options
where application_id = p_application_id
and profile_option_name = p_profile_option_name)
and level_id = p_level_id;

But I have a trigger on same table fnd_profile_option_values which is using

v_user_id := nvl(FND_PROFILE.VALUE('USER_ID'), -99);

so I am getting error for mutating as it is looking into the same table, but when I am running in old dev environment it is working fine.

DO I need to run any script to set fnd_profile so that it will not go to database table to fetch the value, I mean it will use any cached value or something?

Can anybody help?

Thanks and Regards,
Sreejit Nair
Previous Topic: Stock locators Convertion
Next Topic: SQL Loader Problem
Goto Forum:
  


Current Time: Fri Dec 09 13:57:16 CST 2016

Total time taken to generate the page: 0.05989 seconds