Using Office 365 in Workflow Notification mailer in Test environments
Steps1- Configure the mail server and email sender
1. Login using ‘SYSADMIN user and go to responsibility 'System Administration' > Oracle Applications Manager > Click on Workflow
2. Screen displayed as Notification mailer Down
3. Click on 'Service Components'
4. Select Workflow Notification Mailer and click on Edit.
Set the following parameters
a) Outbound EMail Account (SMTP)
Server Name: 'smtp.office365.com'
Username: 'mailer@Company.com'
Password: 'password'
Connection Security: 'STARTTLS'
b) Inbound EMail Account (IMAP)
Server Name: 'outlook.office365.com'
Username:'mailer@Company.com'
Password:'password'
Reply-To Address: 'mailer@Company.com'
Connection Security:'SSL/TLS'
5. Click on button 'Advanced'
6. Press 'Next'
7. Press 'Next'
8. Press 'Next'
9. Update from field to ‘Workflow Mailer Test Environment’ and click on finish.
10. Click on finish
Steps2 - Configure the override address
Override email address is very imported in test environment. all the emails will be redirected to this email. Following are the steps to set it up from back end.
Override email address is very imported in test environment. all the emails will be redirected to this email. Following are the steps to set it up from back end.
1. Run the below sql statement
SELECT fscv.parameter_value
FROM fnd_svc_comp_params_tl fscp, fnd_svc_comp_param_vals fscv
WHERE fscp.display_name = 'Test Address'
AND fscp.parameter_id = fscv.parameter_id;
Query will result with value ‘NONE’ if override is not set earlier.
Query will result with value ‘NONE’ if override is not set earlier.
2. Now run the below sql update statement and commit
UPDATE fnd_svc_comp_param_vals fscpv
SET fscpv.PARAMETER_VALUE = 'erp.test02@company.com' --(Email address to which all emails will be redirected)
WHERE fscpv.parameter_id IN (SELECT fscp.parameter_id
FROM fnd_svc_comp_params_tl fscp
WHERE fscp.display_name = 'Test Address');
3. Now run the below SQL again to verify that the override email address has been set as required.
SELECT fscv.parameter_value
FROM fnd_svc_comp_params_tl fscp, fnd_svc_comp_param_vals fscv
WHERE fscp.display_name = 'Test Address'
AND fscp.parameter_id = fscv.parameter_id;
Query will result with value 'erp.test02@company.com'.
4. Start the workflow mailer from 'System Administration' > Oracle Applications Manager > Click on Workflow
Select Workflow Notification mailer and Click on Select ‘Start’ from drop down list and Press on Go button.
5. Workflow notification mailer should start and the status should be 'Running'.
Steps3 - Test the setup
1. Click on 'Workflow Notification Mailer'.
2. Click on ‘Test Mailer’
3. Select user with email address set and click 'Accept' button. Email address which has been set to override will receive two email.
The emails should not be sent to the actual email address that is set for the user which selected above. Now test environment has been configured to test workflow mailer server.
