Purchase Order Workflow Errors With ERROR_MESSAGE=3835 ORA-20002: [WFMLR_DOCUMENT_ERROR]' PDF_ATTACHMENT_SUPP When Trying to Email Document (Doc ID 1069009.1)

Last updated on JULY 14, 2016

Applies to:

Oracle Purchasing - Version 11.5.10.1 to 11.5.10.4 [Release 11.5]
Information in this document applies to any platform.
***Checked for relevance on 27-May-2014***

Symptoms

When attempting to approve some Purchasing documents the following error occurs.

ERROR
-----------------------
                                                                      
EMAIL_PO_PDF_SUPP    #MAIL           WF_ERROR                                                                               
[WF_ERROR] ERROR_MESSAGE=3835: Error '-20002 - ORA-20002: [WFMLR_DOCUMENT_ERROR]' encountered during execution of Generate function                 
'WF_XML.Generate' for event 'oracle.apps.wf.notification.send'. ERROR_STACK=
Wf_Notification.GetAttrblob(4452775, PDF_ATTACHMENT_SUPP, text/html)
WF_XML.GetAttachment(4452775,text/html)                                                                                                             
WF_XML.GetAttachments(4452775, https://athena.stpete.org/pls/PROD, 4901)
WF_XML.GenerateDoc(oracle.apps.wf.notification.send, 4452775)
WF_XML.Generate(oracle.apps.wf.notification.send, 4452775)
WF_XML.Generate(oracle.apps.wf.notification.send, 4452775)
Wf_Event.setMessage(oracle.apps.wf.notification.send, 4452775, WF_XML.Generate)
Wf_Event.dispatch_internal()


STEPS
-----------------------
The issue is intermittent.

1. From the Purchasing responsibility navigate to the Purchase Order (PO) Entry form
2. Create a Purchase Order (PO) and save
3. Choose the Approve button
4. Under transmission method-->send for approval
PO approves but email fails with error.

Changes

11g database upgrade

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms