Oracle iStore IBEALERT workflow intermittently sending out emails to the customer after placing orde
Hi Guys,
We are on R12.1.2 EBS. When customer creates an istore order the IBEALERT workflow completes with Errors, After opening the workflow it looks like the notify Activity always fails with Error as below:
[WF_ERROR] ERROR_MESSAGE=3835: Error '-6508 - ORA-06508: PL/SQL: could not find program unit being called' encountered during execution of Generate function 'WF_XML.Generate' for event 'oracle.apps.wf.notification.send'. ERROR_STACK= Wf_Event.setMessage(oracle.apps.wf.notification.send, 3223331, WF_XML.Generate) Wf_Event.dispatch_internal()
All the other activities finishes successfully, Also this is intermittent sometimes it is successful and sometimes it fails in Error. I have already looked at Oracle Support and none of the issues are similar to this one, I have checked few packages mentioned on oracle support to see if those are valid and they seem to be fine.