Sending Multiple Emails For Same Record Through Workflow Process Using Workflow Policy (Doc ID 519578.1)

Last updated on FEBRUARY 01, 2017

Applies to:

Siebel Workflow - Version 7.8 [19021] and later
Information in this document applies to any platform.

*** Checked for relevance on 02-Feb-2016 ***

***Checked for relevance on 7-JUL-2015***
***Checked for relevance on 21-JUL-2013***


Symptoms


Customer has a requirement to send an email notification whenever the Opportunity Primary sales Rep position IS UPDATED.

To achieve this, Workflow Policy conditions are defined as follows:

  Opportunity LN Assigned Date IS NOT NULL
  Opportunity Primary Sales Rep Position IS UPDATED.

When these two conditions are met, it should call a Workflow Process that would send an email to certain users.

Issue: The users are getting the same email multiple times for the same user. There is no specific amount of emails sent:  user may get 2, may get 8, may get 30.,etc

Customer expected that for each processed record in S_ESCL_REQ table, there should be a corresponding S_ESCL_LOG record.

However, only one record in S_ESCL_LOG table was located.  Activity records are created for each email the Workflow sends.



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms