Error in PEI ECO Notification [message #428677] |
Thu, 29 October 2009 07:56 |
jatinmajithia
Messages: 2 Registered: October 2009
|
Junior Member |
|
|
Hi,
I got the error which is attached here. I am new to this please help me to sort out this one.
Here is the error -
worflow error [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-06502: PL/SQL: numeric or value error
wf_notification.GetAttrDoc2(15682968, PEI_DETAILS, text/html)
Wf_Notification.GetAttrDoc(15682968, PEI_DETAILS, text/html)
Wf_Notification.GetText(15682968, text/html)
Wf_Notification.GetBody(15682968, text/html)
WF_NOTIFICATION.GetFullBody(nid => 15682968, disptype => text/html)
WF_MAIL.GetLOBMessage3(nid => 15682968, r_ntf_pref => MAILH' encountered during execution of Generate function 'WF_XML.Generate' for event 'oracle.apps.wf.notification.send'. ERROR_STACK=
WF_MAIL.GetLOBMessage3(15682968, WFMAIL, 2020: Error when getting notification content. Caused by: ORA-06502: PL/SQL: numeric or value error
wf_notification.GetAttrDoc2(15682968, PEI_DETAILS, text/html)
Wf_Notification.GetAttrDoc(15682968, PEI_DETAILS, text/html)
Wf_Notification.GetText(15682968, text/html)
Wf_Notification.GetBody(15682968, text/html)
WF_NOTIFICATION.GetFullBody(nid => 15682968, disptype => text/html)
WF_MAIL.GetLOBMessage3(nid => 15682968, r_ntf_pref => MAILHTML), Step -> Getting text/html body)
WF_XML.GenerateDoc(oracle.apps.wf.notification.send, 15682968)
WF_XML.Generate(oracle.apps.wf.notification.send, 15682968)
WF_XML.Generate(oracle.apps.wf.notification.send, 15682968)
Wf_Event.setMessage(oracle.apps.wf.notification.send, 15682968, WF_XML.Generate)
Wf_Event.dispatch_internal()
================
Thanks in advance!!
|
|
|