Query to check Override address in EBS workflow notification Mailer:
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;
PARAMETER_VALUE
--------------------------------------------------------------------------------
NONE
SQL Query to update Override email address from backend in EBS :
SQL> update fnd_svc_comp_param_vals
set parameter_value = 'TEST_EMAIL@DOMAIN.COM'
where parameter_id =
( select parameter_id
from fnd_svc_comp_params_tl
where display_name = 'Test Address');
1 row updated.
SQL> commit;
Commit complete.
Verify that override email address is updated:
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;
PARAMETER_VALUE
--------------------------------------------------------------------------------
TEST_EMAIL@DOMAIN.COM
SQL>
No comments:
Post a Comment
Was this Post Helpful?
Feel free to suggest your opinions in the comments section!