Where Is The Workflow Notification Mailer Smtp And Imap Hostname Stored In DB
#This query tells you where the Workflow notification mailer is running:
select target_node from apps.fnd_concurrent_queues where concurrent_queue_name like 'WFMLRSVC%';
#This query tells you the IMAP inbound server name, SMTP outbound server name, value of reply to email address:
SELECT b.component_name, c.parameter_name, a.parameter_value FROM apps.fnd_svc_comp_param_vals a, apps.fnd_svc_components b, apps.fnd_svc_comp_params_b c WHERE b.component_id = a.component_id AND b.component_type = c.component_type AND c.parameter_id = a.parameter_id AND c.encrypted_flag = 'N' AND b.component_name like '%Mailer%' AND c.parameter_name in ('INBOUND_SERVER','OUTBOUND_SERVER', 'REPLYTO') ORDER BY c.parameter_name;
#This query tells you where the Workflow notification mailer is running:
select target_node from apps.fnd_concurrent_queues where concurrent_queue_name like 'WFMLRSVC%';
#This query tells you the IMAP inbound server name, SMTP outbound server name, value of reply to email address:
SELECT b.component_name, c.parameter_name, a.parameter_value FROM apps.fnd_svc_comp_param_vals a, apps.fnd_svc_components b, apps.fnd_svc_comp_params_b c WHERE b.component_id = a.component_id AND b.component_type = c.component_type AND c.parameter_id = a.parameter_id AND c.encrypted_flag = 'N' AND b.component_name like '%Mailer%' AND c.parameter_name in ('INBOUND_SERVER','OUTBOUND_SERVER', 'REPLYTO') ORDER BY c.parameter_name;
No comments:
Post a Comment