Workflow Email Notifications with Embedded Framework Regions Not Sent – Error in Mailer Log

When using Oracle E-Business Suite Workflow Mailer, you may encounter an issue where email notifications with embedded framework regions are not sent out. Instead, the mailer log shows the following error:

Problem getting the HTML content ->
oracle.apps.fnd.wf.mailer.NotificationFormatter$FormatterSAXException:
Problem obtaining the HTML content ->
oracle.apps.fnd.wf.common.HTTPClientException:
Unable to invoke method HTTPClient.HTTPConnection.Get

Problem Reproduction

 Business Impact


  • Users are unable to receive workflow emails with embedded framework regions.
  • Approval processes are delayed.

Reason

  • If WF_MAIL_WEB_AGENT is not set, it defaults to APPS_FRAMEWORK_AGENT.
  • If this value points to a load balancer (BigIP) or virtual hostname instead of a physical web server, framework notifications (e.g., REQAPPRV) will fail, while simple notifications (e.g., POAPPROV) may still work.

 Solution

Follow the steps below to resolve the issue safely.

Step 1: Stop Workflow Mailer and Agent Listener

SELECT component_name, component_status, component_status_info
FROM fnd_svc_components_v
WHERE component_name LIKE 'Workflow%';

Step 2: Identify Tablespace for Queue Indexes

SELECT DISTINCT tablespace_name
FROM dba_indexes, dba_queues
WHERE index_name LIKE 'WF%N1'
AND table_name = queue_table
AND name LIKE 'WF%';

Step 3: Set WF_MAIL_WEB_AGENT Profile Option


  • Set WF: Workflow Mailer Framework Web Agent to a physical web server:

Example: 
http://myhost.mydomain.com:8000

To identify values, grep the context file (<SID>_hostname.xml):

grep -ie s_webhost $CONTEXT_FILE
grep -ie s_domainname $CONTEXT_FILE
grep -ie s_webport $CONTEXT_FILE

Validate using wget:

wget http://<s_webhost>.<s_webdomain>:<s_webport>
# Expect: 200 OK

 Note:

  • Always use http, not https.
  • Port should be s_webport, not the SSL port.

Step 4: Rebuild Workflow Mailer Queue

sqlplus apps/<password>
SQL>@$FND_TOP/patch/115/sql/wfntfqup.sql APPS <apps_password> APPLSYS

 If errors occur, refer to:

Doc ID 2200114.1 – Rebuilding WF_NOTIFICATION_OUT Queue Errors
Doc ID 400493.1 – Manually Recreate WF_NOTIFICATION_OUT Queue
Doc ID 2026049.1 – Unable To Drop WF_NOTIFICATION_OUT Queue

Step 5: Recreate Index on CORRID Column

sqlplus applsys/<password>
CREATE INDEX WF_NOTIFICATION_OUT_N1
ON WF_NOTIFICATION_OUT(CORRID)
TABLESPACE <tablespace> -- found in previous query
STORAGE 
(INITIAL 1M NEXT 1M MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0);

Step 6: Restart Workflow Mailer and Agent Listener

Start Workflow services again from Oracle Application Manager.

Confirm: 
SELECT component_name, component_status, component_status_info
FROM fnd_svc_components_v
WHERE component_name LIKE 'Workflow%';

Step 7: Wait & Retest

  • Allow ~30 minutes for Workflow Mailer to process pending emails.
  • Send a fresh notification to validate.

 Important Note

Ensure the context variable s_wfmail_agent also points to the same physical web node.

If left blank, next AutoConfig run may overwrite the profile option and reintroduce the issue.




Please do like and subscribe to my youtube channel: https://www.youtube.com/@foalabs If you like this post please follow,share and comment