Errors When Sending Supplier Notification- ERROR_MESSAGE=3835: Error '-20002 - ORA-20002: 2018: Unable to generate the notification XML' and ORA-1403 No Data Found (Doc ID 757147.1)

Last updated on AUGUST 21, 2016

Applies to:

Oracle Purchasing - Version 11.5.10.2 to 12.0.4 [Release 11.5 to 12]
Information in this document applies to any platform.
***Checked for relevance on 23-Oct-2012***

Symptoms

When approving purchase orders (PO) the workflow fails when sending the email PO notification to the supplier:

ERROR

Failed Activity E-Mail PO
Error Name WF_ERROR
Error Message [WF_ERROR] ERROR_MESSAGE=3835: Error '-20002 - ORA-20002: 2018: Unable to generate the notification XML.
Caused by: 2020: Error when getting notification content.
Caused by: ORA-01403: no data found ORA-01403: no data found wf_notification.GetAttrDoc2(389885,PO_EMAIL_HEADER, text/html) Wf_Notification.GetAttrDoc(389885, PO_EMAIL_HEADER, text/html)
Wf_Notification.GetText(389885, text/html) Wf_Notification.GetBody(389885, text/html)
WF_NOTIFICATION.GetFullBody(nid => 389885, disptype => text/html) WF_MAIL.GetLOBMessage3(nid=> 389885, r_ntf_pref => M' encountered during execution of Generate function 'WF_XML.Generate' for event 'oracle.apps.wf.notification.send'.

ERROR_STACK=
WF_MAIL.GetLOBMessage3(389885, WFMAIL, 2020: Error when getting notification content.
Caused by:ORA-01403: no data found ORA-01403: no data found wf_notification.GetAttrDoc2(389885,
PO_EMAIL_HEADER, text/html) Wf_Notification.GetAttrDoc(389885, PO_EMAIL_HEADER, text/html)
Wf_Notification.GetText(389885, text/html) Wf_Notification.GetBody(389885, text/html)
WF_NOTIFICATION.GetFullBody(nid => 389885, disptype => text/html) WF_MAIL.GetLOBMessage3(nid=> 389885, r_ntf_pref => MAILHTM2), Step -> Getting text/html body)
WF_XML.GenerateDoc(oracle.apps.wf.notification.send, 389885)
WF_XML.Generate(oracle.apps.wf.notification.send, 389885)
Wf_Event.setMessage(oracle.apps.wf.notification.send, 389885, WF_XML.Generate)
Wf_Event.dispatch_internal()

Steps to reproduce the issue:
1. Approve purchase order
2. The workflow fails when sending the email PO notification to the supplier

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