| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
