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 SEPTEMBER 23, 2022

Applies to:

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

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.