1. Not Receiving PROD Alert emails
Background
Business stopped getting alert emails. Although an alert email is generated everyday, 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 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 valid email address and restarted Workflow Notification Mailer to test periodic alerts.
Permanent fix was to update the context file with 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, for users whose profile is set for Java Plug-in, they still don’t see workflow diagram in 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 (ie http://webserver.domain.com:<port>)
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 {{OUTBOUND_USER=, FROM=Workflow Mailer-EBSPROD, REPLYTO=NoReplyTo@xyz.ca, OUTBOUND_SERVER=hostname, OUTBOUND_PASSWORD=*****, COMPONENT_ID=10006}}
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 to change any and all of your Mailer components.
a. Run the script
b. It will show you the components – pick the comp id for the Workflow Mailer – default is 10006
c. Then it will show you the parameters and their values for the mailer
d. 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 Backend ? ( Doc ID 1533596.1 ).
AninditaK 