Change Override address in Workflow Mailer

Change Override address in Oracle workflow mailer from backend

1) Check current Override address
select fscpv.PARAMETER_VALUE from fnd_svc_comp_param_vals fscpv
where fscpv.parameter_id in (select fscpt.parameter_id
from fnd_svc_comp_params_tl fscpt
where fscpt.display_name = 'Test Address');


2) Update with new override address
update fnd_svc_comp_param_vals fscpv
set fscpv.PARAMETER_VALUE = 'vivek.bhutani@xyz.com'
where fscpv.parameter_id in (select fscpt.parameter_id
from fnd_svc_comp_params_tl fscpt
where fscpt.display_name = 'Test Address');


3) Confirm the new override address
select fscpv.PARAMETER_VALUE from fnd_svc_comp_param_vals fscpv
where fscpv.parameter_id in (select fscpt.parameter_id
from fnd_svc_comp_params_tl fscpt
where fscpt.display_name = 'Test Address');