Workflow Mailer Over-riding

Pre-Reqs:
Check the below parameters having proper values according to your environment before over-riding, otherwise issue will occur.

• Masking Email Address
• uname -n
• hostname
• grep -ie s_webhost $CONTEXT_FILE
• grep -ie s_domainname $CONTEXT_FILE
• grep -ie s_webport $CONTEXT_FILE

For e-mail address masking Click Here

Use the below query to check the details of Framework and Web agents.

select PROFILE_OPTION_NAME, PROFILE_OPTION_VALUE from fnd_profile_options a , fnd_profile_option_values b where a.APPLICATION_ID = b.APPLICATION_ID and a.PROFILE_OPTION_ID = b.PROFILE_OPTION_ID and a.PROFILE_OPTION_NAME in ( 'APPS_FRAMEWORK_AGENT', 'WF_MAIL_WEB_AGENT') and b.level_value = 0;

Values of both the agents should be same, otherwise you will receive notification for only one test notification(PL/SQL) out of two.

Suppose if 'WEB_AGENT' is having a different value means, follow either  Doc ID 1943176.1 or Doc ID 736898.1 to fix that(For step by step process Click Here ) and continue with the below given steps

Below are the step-by -step process for workflow mailer over-riding.

Start all the service components before setting over-ride mail id, to make sure all the components are running fine without any issues.

Once all the components are UP and Running, bring down all the services down before setting the over-ride mail id.

Once the components are down, select the radio button for the component 'Workflow Notification Mailer' and select View Details > Edit

Here the following things should be taken care.

1. Outbound EMail Account(SMTP) server name should be a valid one.
2. Username should be empty.
3. Inbound EMail Account(IMAP) Reply-To Address should be a valid one.
4. You can set the Reply-To Address to the OS user of your Application server along with fully qualified host name.

         For eg : If your OS username is applmgr and the hostname is test.apple.net, then the Reply-To Address should be 'applmgr@test.apple.net'

  Now go to the Advanced.

Now move to step 3 and remove username and save. Here the Outbound Server Name should be a valid(which can process and send mails) SMTP server name. Mostly in Production environments a valid SMTP mailer name will be configured. For testing purpose this mailer name can be used on a test instance to carry out mailer over-riding process(Of-course on approval)!!!

Once this settings are completed, initiate a test mail to check the WFM is working properly. Here the mail_status is sent, which means WFM is working as expected.

Now you can set the override address from both Front-End and Back-End.

From Front-End

Now come back to the details page and click on tab 'Set Override Address'

Now give the override mail id and submit.

Check with the user who owns the override mail id and get the verification code sent via mail, enter the verification code and Apply.

Once the above steps are performed successfully without any issues, start all the workflow components.

Now initiate a test mail as below

By default override mail address will be there. Choose a proper recipient role and send the test mail. If you don't know the appropriate recipient role, check with the user who owns the overriding mail id.

Once the test mail is initiated, check whether the user received the test mails. Normally two test mails will be sent to the over-riding mail id. One framework and one PLSQL message.

You can use the below queries to check the status of your notification mail status.

select * from wf_notifications order by begin_date desc;

select begin_date,mail_status,status,message_name from wf_notifications where notification_id in ('10026201','10026200'); -- Here replace your notification id's.

From Back-End

1. Run the script $FND_TOP/sql/afsvcpup.sql as APPS user
2. Enter the comp id for Workflow Mailer. Default value is 10006
3. Enter the comp param id for override address. It'll be shown as Test Address. Default value is 10093
4. When asked enter the mail id you want to set as override address.
5. Bounce the WFM and confirm the results.

Ref: How to set Workflow Mailer Override Address from Backend ? (Doc ID 1533596.1)

****************************நன்றி****************************