Download the latest Gartner® report: “Use this checklist to ensure your data is ready for the era of agentic AI”

Oracle Workflow Notification Mailer Issues

Anindita Kar Sep 26, 2023 12:00:00 AM

Contents

Send Email from OCI Email Delivery Service Through UTL_SMTP

Azure VM Selection Made Easy: A Script Identifying Best Constrained CPU VMs for High Memory/Low CPU Workload – Eclipsys

Firewall for Outgoing Layer7 Web Traffic on OCI – Eclipsys

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.

workflow

 

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
workflow2

 

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
         
  
   NoReplyTo@xyz.ca

 

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.

workflow3

 

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: 😉
  2. Stop Workflow Agent, Listener,
  3. Rebuild Mailer queue
  4. Start Workflow Agent listener
    5.

 

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 
   
    … 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 :

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 ).
Oracle Autonomous Health Framework

Send Email from OCI Email Delivery Service Through UTL_SMTP

Azure VM Selection Made Easy: A Script Identifying Best Constrained CPU VMs for High Memory/Low CPU Workload – Eclipsys

Firewall for Outgoing Layer7 Web Traffic on OCI – Eclipsys
Previous

AWS to OCI: How our Clients are Saving Money, Improving Performance, and Reducing Risk
Next

Peering OCI VCNs in the Same Tenancy Region Using Dynamic Routing Gateway