This is directed to all the Workflow Guru's out on OTN.
From last night, it seems that my users are not receiving notifications. This came to light only this morning - and after taking a look at the log files from the Oracle Application Manager (OAM) service components page, I find several (almost 750) lines with text similar to the following:
"[Jun 17, 2007 10:28:02 PM CDT]:1182137282297:Thread[outboundThreadGroup1,5,outboundThreadGroup]:0:-1:mkewis01.drs-pct.com:10.40.9.61:-1:-1:ERROR:[SVC-GSM-WFMLRSVC-9546-10006 : oracle.apps.fnd.wf.mailer.SMTPMessageHandler.processMessage(Object)]:Not sending notification 699375 because could not locate the row in the notification table"
The only thing I can think of is that all tiers (DB and APPL_TOP) were bounced on Friday morning and again on Saturday evening.
Is there a concurrent process (like a background engine) that processes emails and dumps lines into the WF_NOTIFICATIONS table? Because it seems as though the table referenced about is the WF_NOTIFICATIONS table.