My Oracle Support Banner

Automated E-mail Notifications For Open Leads/Opportunities Older Than 3 Months (Doc ID 2160712.1)

Last updated on NOVEMBER 17, 2019

Applies to:

Oracle Fusion Sales Cloud Service - Version to [Release 1.0]
Information in this document applies to any platform.


Automated e-mail notifications for open Leads/Opportunities older than 3 months

You have a business requirement from your client to send an automated e-mail to the Opportunity owner when an Opportunity or a Lead is still open 3 months after the creation date.
You are aware how to make Sales Cloud send an e-mail when there is a field change (we have trigger), but the point in this case is that these notification e-mails should be sent out automatically without any user interaction required, only based on the creation date being older than 3 months.
And you want to understand how to achieve this.


Auto send of email notifications after 3 months

The issue can be reproduced at will with the following steps:
1. Create object workflow
2. The object workflow triggers instantaneously when criteria is met


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.