Accepting Change Request Results In Purchase Order Approval Error PO_PO_APPROVED #MAIL ERROR_MESSAGE=3835:ORA-20002: 2018: ORA-01403: no data found (Doc ID 755076.1)

Last updated on FEBRUARY 04, 2022

Applies to:

Symptoms

When conducting a change order, the purchase order approval workflow fails and errors are encountered.
The workflow never completes.

Error:
PO_PO_APPROVED #MAIL WF_ERROR [WF_ERROR] ERROR_MESSAGE=3835:
Error '-20002 - ORA-20002: 2018:
ORA-01403: no data found

wf_notification.GetAttrDoc2(2786860, ACTION_HISTORY, text/html)
Wf_Notification.GetAttrDoc(2786860, ACTION_HISTORY, text/html)
Wf_Notification.GetText(2786860, text/html)
Wf_Notification.GetBody(2786860, text/html)
WF_NOTIFICATION.GetFullBody(nid => 2786860, disptype => text/html)
WF_MAIL.GetLOBMessage3(nid => 2786860, r_ntf_pref ' encountered during execution of Generate
function 'WF_XML.Generate' for event '
WF_MAIL.GetLOBMessage3(2786860, WFMAIL, 2020: Error when getting notification content. Caused by:
ORA-01403: no data found
ORA-01403: no data found

wf_notification.GetAttrDoc2(2786860, ACTION_HISTORY, text/html)
Wf_Notification.GetAttrDoc(2786860, ACTION_HISTORY, text/html)
Wf_Notification.GetText(2786860, text/html)
Wf_Notification.GetBody(2786860, text/html)
WF_NOTIFICATION.GetFullBody(nid => 2786860, disptype => text/html)
WF_MAIL.GetLOBMessage3(nid => 2786860, r_ntf_pref => MAILHTML), Step -> Getting text/html
body)
WF_XML.GenerateDoc(oracle.apps.wf.notification.send, 2786860)
WF_XML.Generate(oracle.apps.wf.notification.send, 2786860)
WF_XML.Generate(oracle.apps.wf.notification.send, 2786860)
Wf_Event.setMessage(oracle.apps.wf.notification.send, 2786860, WF_XML.Generate)
Wf_Event.dispatch_internal()
1 row selected

Replication Steps:
1. Create the Change Order from the iSupplier Portal
2. Buyer accepts the changes and the Purchase Order Approval process is invoked.
3. Error occurs in the POAPPRV workflow, viewable in the status monitor.
Meanwhile the workflow process never completes.

Cause

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