HOW TO SET THE OVERRIDE ADDRESS in WORKFLOW MAILER

Step 1: Connect to CM node as Apps user

Step 2: Check test email id

col PARAMETER_VALUE for a25

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;

Step 3: Update with new test mail


update fnd_svc_comp_param_vals fscpv
set fscpv.parameter_value = '12345@abcdef.com'
where fscpv.parameter_id = 10057;


Commit;


Step 4: Check test email id

col PARAMETER_VALUE for a25

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;


Step 5: Check from Front-end Also