0 Replies Latest reply on Jun 19, 2007 1:20 AM by EXAPUB

    Work Flow Question # 2

      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:[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.

      Thanks in advance