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"
7) Edit the "Reply-to-Address"
8) Disable/Enable scheduled workflow start/stop events if needed.
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)
