Tag Archives: Workflow

EBS Workflow Notification Mailer Override Address 

You can verify Override Address using the below SQL:

select fscpv.parameter_value from fnd_svc_comp_params_tl fscpt ,fnd_svc_comp_param_vals fscpv where fscpt.display_name = ‘Test Address’ and fscpt.parameter_id = fscpv.parameter_id;

Update Override Address using the below SQL:

update fnd_svc_comp_param_vals fscpv set fscpv.PARAMETER_VALUE = ‘admin@oracle-homes.com’ where fscpv.parameter_id in ( select fscpt.parameter_id from fnd_svc_comp_params_tl fscpt where fscpt.display_name = ‘Test Address’);

You can verify the same Override Address using the below SQL:

select fscpv.parameter_value from fnd_svc_comp_params_tl fscpt ,fnd_svc_comp_param_vals fscpv where fscpt.display_name = ‘Test Address’ and fscpt.parameter_id = fscpv.parameter_id;

Happy Learning!!