Showing posts with label setup mail id for oracle workflows. Show all posts
Showing posts with label setup mail id for oracle workflows. Show all posts

Tuesday, 11 July 2017

Check Default mail id setup for Oracle Workflows

Query to Check Default mail id setup for Workflows:-

select p.parameter_id,
p.parameter_name,
v.parameter_value value
from apps.fnd_svc_comp_param_vals_v v,
apps.fnd_svc_comp_params_b p,
apps.fnd_svc_components c
where c.component_type = 'WF_MAILER'
and v.component_id = c.component_id
and v.parameter_id = p.parameter_id
and p.parameter_name in ( 'INBOUND_SERVER','ACCOUNT', 'REPLYTO')
order by p.parameter_name;