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 SEPTEMBER 13, 2016

Applies to:

Oracle iSupplier Portal - Version 11.5.10 to 11.5.10 [Release 11.5]
Oracle Purchasing - Version 11.5.10 to 11.5.10.4 [Release 11.5]
Information in this document applies to any platform.
iSupplier Portal - Version: 11.5.10

Checked for currency in Jul-12-2013

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

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