Purchasing Requisition Workflow Mailer Notification Not Sending Email

Symptoms
PO Requisitions and other notification emails are not being sent. The Test Mailer Framework Type email is sent.

Cause

When "Attach images to outbound emails" is enabled the Workflow Mailer will embed any referenced image URL into the email message.  PO Requisition (PO_REQ_APPROVE_JRAD) message includes an image that will be included in the email message.  The complete URL pointing to this images is not is not being populated by the Workflow Mailer code.  The code should retrieve http://<host.domain:port>/OA_MEDIA/ag_transparentpixel.gif.  It is actually retrieving http://. This is not a valid URL.

Solution :

- Workaround :

   1. Disable functionality "Attach Images to Outbound Emails"

       Navigator : System Administrator  ->  Oracle Application Manager  ->  Workflow  ->  Notification Mailer  ->  Edit  ->  Advance  -> Details  ->  EMail Servers  ->  Message Generation.

Uncheck the field "Attach Images to Outbound Emails" like image below :

   

2. Restart workflow mailer service   

    Navigator : System Administrator  ->  Oracle Application Manager  ->  Workflow  ->  Notification Mailer.

Select workflow mailer service and click Stop then wait for state=Deactivated. After that click start.

- Permanent Solution :

1. Backup your system (application and database)

2. Apply patch number below 9868639

3. Retest the issue

Source : Metalink, doc id 1116718.1