Purchase Order Workflow Errors with ERROR_MESSAGE=3835: ORA-20002: 2018: Unable to generate the notification XML - ORA-01403 No Data Found - ORA-06512: at APPS.WF_NOTIFICATION (Doc ID 973355.1)

Last updated on JULY 14, 2016

Applies to:

Oracle Purchasing - Version 12.0.6 and later
Information in this document applies to any platform.
***Checked for relevance on 24-Mar-2014***

Symptoms

After upgrading to 12.0.6 the following error is seen when opening some Purchase Order notifications. This is not specific to one user. The error message appears regardless of whether or not the email notification or the worklist notification is used.  This presents on both new notifications created before the upgrade to 12.0.6, as well as after the upgrade to 12.0.6. 

ERROR:
ORA-04103: no data found
ORA-01403: no data found
ORA-06512: at "APPS.WF_NOTIFICATION"...

[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(486674, ACTION_HISTORY, text/html)
Wf_Notification.GetAttrDoc(486674, ACTION_HISTORY, text/html)
Wf_Notification.GetText(486674, text/html)
Wf_Notification.GetBody(486674, text/html)
WF_NOTIFICATION.GetFullBody(nid => 486674, disptype => text/html)
WF_MAIL.GetLOBMessage3(nid => 486674, r_ntf_pref => MAI' encountered during
execution of Generate function 'WF_XML.Generate' for eve
nt 'oracle.apps.wf.notification.send'.

ERROR_STACK=
WF_MAIL.GetLOBMessage3(486674, WFMAIL, 2020: Error when getting notification
content. Caused by: ORA-01403: no data found

Changes

Upgrade to Release 12.0.6

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