Purchase Order approval Email Errors When PO Has Only Text Attachments AME_PO_APPROVE_NOTIF #MAIL WF_ERROR [WF_ERROR] ERROR_MESSAGE=3835: Error '100 - ORA-1403: no data found' (Doc ID 2588266.1)

Last updated on JANUARY 03, 2022

Applies to:

Symptoms

On : 12.2.7 version, Workflow Mailer

When attempting to approve POs that have just a short or long text attachment the email to the approver fails (notification is generated successfully in the worklist)

ERROR

Activity (Display Name) RESULT ERROR_NAME ERROR_MESSAGE ERROR_STACK AME_PO_APPROVE_NOTIF (AME PO Approve Notification) #MAIL WF_ERROR [WF_ERROR]
ERROR_MESSAGE=3835: Error '100 - ORA-1403: no data found' encountered during execution of Generate function 'WF_XML.Generate' for event
'oracle.apps.wf.notification.send'. ERROR_STACK= WF_XML.GetAttachments(1397655, XXXXX, 4684) WF_XML.GenerateDoc(oracle.apps.wf.notification.send, 1397655)
WF_XML.Generate(oracle.apps.wf.notification.send, 1397655)
Wf_Event.setMessage(oracle.apps.wf.notification.send, 1397655,
WF_XML.Generate) Wf_Event.dispatch_internal()

NOTE: If the PO has no attachments or a combination of File attachments AND short / long text error does not occur

NOTE : The notification looks ok via the Notification Worklist

STEPS TO REPLICATE 

1) Create a Purchase add only short text or long text 

2) During approval email error  

Cause

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