Workflow mailer configuration setup

1)      Login to Oracle Applications Manager using sysadmin account

2)      In the drop down box choose “Workflow Manager” and click GO

3)      Click on Service componets

4)      Choose Workflow Notification Mailer and then click on Edit

Make sure you brought down the workflow services before edit to avoid the unnecessary notifications

   5) Enter the "Outbound Server Name"

   6) Edit the "From"
   7) Edit the "Reply-to-Address"

   8) Disable/Enable scheduled workflow start/stop events if needed.

  9) Review the details and Finish

SQL query to verify the workflow details:

set lines 1000
col VALUE for a40
select p.parameter_id,
p.parameter_name,
v.parameter_value value
from fnd_svc_comp_param_vals_v v,
fnd_svc_comp_params_b p,
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 ('OUTBOUND_SERVER', 'INBOUND_SERVER','ACCOUNT', 'FROM', 'NODENAME', 'REPLYTO','DISCARD' ,'PROCESS','INBOX');

SQL query to verify the workflow services status:

set lines 1000
col COMPONENT_STATUS_INFO for a40
col COMPONENT_NAME for a50
SELECT component_name, component_status, component_status_info
FROM fnd_svc_components_v
WHERE component_name like 'Workflow%';

Few reference documents:

How to Verify/Start WorkFlow Background Engine? [ID 112935.1]
How to Stop/Start Workflow Service Containers From Command Line (Doc ID 743264.1)
How To Automatically Refresh, Resume, Start, Stop, Suspend, or Launch Summary Notifications for the Workflow Mailer as needed? (Doc ID 443643.1)