My Oracle Support Banner

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

Last updated on OCTOBER 28, 2022

Applies to:

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

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


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.


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.