Error has occurred in workflow processing
Hi All,
The email notification sent back to employees to notify them that the timecard was submitted successfully is erroring. I looked in the workflow administrator resp and noticed the employee notifications were failing.
Please see the below error:
Failed Activity Notifications to Employee (FYI)
Activity Type Notice
Error Name WF_ERROR
Error Message 9004: An error has occurred in workflow processing: 3835: Error '-20002 - ORA-20002: 2018: Unable to generate the notification XML. Caused by: 2323: Message template 'NOTE_EMP' in item type 'WFMAIL' can not be found WF_MAIL.getTemplateName(nid => 882116, n_status => OPEN, n_mstatus => MAIL, t_type => WFMAIL, t_name => NOTE_EMP) WF_MAIL.getTemplateName(882116, OPEN, MAIL, WFMAIL, NOTE_EMP) WF_MAIL.ProcessSignaturePolicy(882116)' encountered during execution of Generate function 'WF_XML.Generate' for event 'oracle.apps.wf.notification.send'.. The stack trace of the error is: WF_MAIL.GetLOBMessage3(882116, WFMAIL, 2323: Message template 'NOTE_EMP' in item type 'WFMAIL' can not be found WF_MAIL.getTemplateName(nid => 882116, n_status => OPEN, n_mstatus => MAIL, t_type => WFMAIL, t_name => NOTE_EMP) WF_MAIL.getTemplateName(882116, OPEN, MAIL, WFMAIL, NOTE_EMP) WF_MAIL.ProcessSignaturePolicy(882116), Step -> Getting Signature policy) WF_XML.GenerateDoc(oracle.apps.wf.notification.send, 882116) WF_XML.Generate(oracle.apps.wf.notification.send, 882116) WF_XML.Generate(oracle.apps.wf.notification.send, 882116) Wf_Event.setMessage(oracle.apps.wf.notification.send, 882116, WF_XML.Generate) Wf_Event.dispatch_internal()
Can any one help me how to fix this issue?
Thanks & regards,
Raju