Oracle Workflow Notification Mailer Issues

1. Not Receiving PROD Alert Emails

Background

Businesses stopped getting alert emails. Although an alert email is generated every day, users haven’t received any.

Action Plan

Workflow reply-to-address changed to NoReplyto, stopping the Periodic alerts altogether for 1 month or so. This was caused by Jan RU Patching (28th Jan), which triggered Autoconfig and caused a change in the XML file configuration.

Here’s an extract from the workflow log –

[Jan 31, 2023 5:51:07 AM EST]:1675162267525:-1:-1:hostname:IP:-1:-1:1:20420:SYSADMIN(0):-1:Thread[outboundThreadGroup1,5,outboundThreadGroup]:IPaddr:58377:1674941037630:12:UNEXPECTED:[SVC-GSM-WFMLRSVC-139668-10006 : oracle.apps.fnd.wf.mailer.NotificationFormatter.getFormattedMessages()]:Problem parsing XML -> org.xml.sax.SAXException: Replyto must be a valid email address

As a fix, I manually updated the reply-to-address to the valid email address and restarted the Workflow Notification Mailer to test periodic alerts.
The permanent fix was to update the context file with the valid email address –

[applmgr@hostname ~]$ cat $CONTEXT_FILE |grep -i reply
         <username oa_var="s_javamailer_reply_to" customized="yes">NoReplyTo@xyz.ca</username>

2. Workflow Diagram not coming up after enabling Java Web Start

Background

Workflow Diagram not coming up after enabling Java Web Start.

Earlier, JWS was enabled following Doc 2188898.1, Section 5.2 Enabling Java Web Start, Option 3.

However, users whose profile is set for Java Plug-in, still don’t see the workflow diagram in the browser.

Action Plan

1. The profile “WF: Workflow Mailer Framework Web Agent” was blank earlier.
   I updated the profile “WF: Workflow Mailer Framework Web Agent” to point to a specific physical Web Server host address that is non-load balanced (i.e. http://webserver.domain.com:<port&gt😉
2. Stop Workflow Agent, Listener,
3. Rebuild Mailer queue
4. Start Workflow Agent listener

3. EBS Workflow Notification Mailer error when adding Override Email Address

Background

Getting the following error when trying to add an override email address for Workflow Notification Mailer from the EBS page –

An error has occurred! FAILURE: javax.mail.SendFailedException: Invalid Addresses; nested exception is: class com.sun.mail.smtp.SMTPAddressFailedException: 550 5.7.1 <emailadress@xyz.ca>… Relaying denied Parameters 

Action Plan

To resolve the issue, test the following steps in a development instance and then migrate accordingly:

1. Use the script $FND_TOP/sql/afsvcpup.sql.
This will enable you to change any and all of your Mailer components.

1. Run the script
2. It will show you the components – pick the comp ID for the Workflow Mailer – the default is 10006
3. Then it will show you the parameters and their values for the mailer
4. Pick the comp param id for the Override address (it will say Test Address ) – default is 10093

2. The script will display the following:

You have selected parameter : Test Address
Current value of parameter : NONE
Enter a value for the parameter : <Here you will put the email address you want >

3. Retest the Workflow mailer and confirm the override now works as expected. Reference: How to set Workflow Mailer Override Address from the Backend? ( Doc ID 1533596.1 ).