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>
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
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.
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 ).