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

    Work Flow Question # 2

    EXAPUB
      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.

      Thanks in advance

      Joe