My Oracle Support Banner

Notification Failed To Isupplier User (Doc ID 2597583.1)

Last updated on OCTOBER 11, 2019

Applies to:

Oracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Approvals - Req, PO

ACTUAL BEHAVIOR
---------------
 Notification failed to isupplier user

After PO approved, the isupplier user is not getting any notification.
wf_notifications table shows mail_status = 'FAILED'.


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-20002: 3240: Error '10 0 - ORA-01403: no data found ORA-01403: no data found ' in 'PLSQL' API 'PO_EMAIL_GENERATE.GENERATE_HEADER' wf_notification.GetAttrDoc2(1157785, PO_EMAIL_HEADER, text/html) Wf_Notification.GetAttrDoc(1157785, PO_EMAIL_HEADER, text/html) Wf_Notification.GetText2(1157785, text/html) Wf_Notification.GetBody(1157785, text/html) WF_NOTIFICATION.GetFullBody(nid =' encountered during execution of Generate function 'WF_XML.Generat e' for event 'oracle.apps.wf.notification.send'. ERROR_STACK= WF_MAIL.GetLOBMessage4(1157785, WFMAIL, 2020: Error when getting notification content. Caused by: OR A-20002: 3240: Error '100 - ORA-01403: no data found ORA-01403: no data found ' in 'PLSQL' API 'PO_EMAIL_GENERATE.GENERATE_HEADER' wf_notification.GetAttrDoc2(1157785, PO_EMAIL_HEADER, text/html) Wf_Notification.GetAttrDoc(1157785, PO_EMAIL_HEADER, text/html) Wf_Notification.GetText2(1157785, text/html) Wf_Notification.GetBody(1157785, text/html) WF_NOTIFICATION.GetFullBody(nid => 1157785, disptype => text/html) WF_MAIL.GetLOBMessage4(nid => 1157785, r_ntf_pref => MAILHTML), Step -> Getting text/html body) WF_XML.GenerateDoc(oracle.apps.wf.notification.send, 1157785) WF_XML.GenerateGroupDoc(oracle.apps.wf.notification.send, 1157785) WF_XML.Generate(oracle.apps.wf.notification.send, 1157785) WF_XML.Generate(oracle.apps.wf.notification.send, 1157785) Wf_Event.setMessage(oracle.apps.wf.notification.send, 1157785, WF_XML.Generate) Wf_Event.dispatch_internal()
Error WF_ERROR

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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