Category: Oracle EBS

Get the override e-mail address from the backend

select parameter_value
from fnd_svc_comp_param_vals
where  parameter_id = 
( select parameter_id
  from   fnd_svc_comp_params_tl
  where  display_name = 'Test Address'
);

Set the override e-mail address from the backend

update fnd_svc_comp_param_vals 
set parameter_value = 'test@email.com' 
where  parameter_id = 
( select parameter_id
  from fnd_svc_comp_params_tl
  where  display_name = 'Test Address'
);

afsvcpup.sql