EBS -- Workflow Mailer Problem parsing XML -> org.xml.sax.SAXException: Problem obtaining the RESOURCE content

You may encounter this issue on EBS 12.2 environments, after modifying the value of
WF_MAIL_WEB_AGENT profile.

This profile option specifies the host and port of the Web server that notification mailers use to generate the content for Oracle Applications Framework regions that are embedded in notifications. If this profile option is not set, notification mailers will use the same Web agent specified in the Application Framework Agent profile option.

I'm writing this because, there is no recorded bugs for this issue for EBS 12.2. (Actually there are bugs records and fixes for these types of problems which may be encountered in earlier releases)

Look at the real life example below;

Error log entry in Notitication mailer's log file:

oracle.apps.fnd.wf.mailer.NotificationFormatter.getFormattedMessages()]:Problem parsing XML -> org.xml.sax.SAXException: Problem obtaining the RESOURCE content -> java.net.MalformedURLException: For input string: "8000 "

Impact:

Notification emails can not be delivered by the Workflow Mailer.

Take a closer look at the log :

java.net.MalformedURLException: For input string: "8000 "

You see the space there? I mean"8000 " -> there is a space there... This value comes from the WF_MAIL_WEB_AGENT profile. In this real life example, it is probably a copy&paste victim.

So , because of that space , java throws MalformedURLException..

Solution:

Modify the WF_MAIL_WEB_AGENT and delete the space from there (better to delete the value and rewrite) and restart the workflow notification mailer.

That is it... That is the tip of the day.