Notification Error when using PL/SQL document
432580Feb 22 2006 — edited Mar 25 2013I have a notification that calls a procedure that returns some HTML body of the email. It worked once, but now I get the error below. In Oracle Apps on the notification tab the notification shows correctly, it's the actual sending of the email that is failing.
Thank you for any help you may be able to provide,
Blake
[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: sqlerrm wf_notification.GetAttrDoc2(123387, NOTIF_BASIC_INFO_DOC, text/html) Wf_Notification.GetAttrDoc(123387, NOTIF_BASIC_INFO_DOC, text/html) Wf_Notification.GetText(123387, text/html) Wf_Notification.GetBody(123387, text/html) WF_NOTIFICATION.GetFullBody(nid => 123387, disptype => text/html) WF_MAIL.GetLOBMessage3(nid => 123387, r_ntf_pref => MAILHTML)' encountered during execution of Generate function 'WF_XML.Generate' for event 'oracle.apps.wf.notification.send'. ERROR_STACK= WF_MAIL.GetLOBMessage3(123387, WFMAIL, 2020: Error when getting notification content. Caused by: sqlerrm wf_notification.GetAttrDoc2(123387, NOTIF_BASIC_INFO_DOC, text/html) Wf_Notification.GetAttrDoc(123387, NOTIF_BASIC_INFO_DOC, text/html) Wf_Notification.GetText(123387, text/html) Wf_Notification.GetBody(123387, text/html) WF_NOTIFICATION.GetFullBody(nid => 123387, disptype => text/html) WF_MAIL.GetLOBMessage3(nid => 123387, r_ntf_pref => MAILHTML), Step -> Getting text/html body) WF_XML.GenerateDoc(oracle.apps.wf.notification.send, 123387) WF_XML.Generate(oracle.apps.wf.notification.send, 123387) WF_XML.Generate(oracle.apps.wf.notification.send, 123387) Wf_Event.setMessage(oracle.apps.wf.notification.send, 123387, WF_XML.Generate) Wf_Event.dispatch_internal()