My Oracle Support Banner

Object Workflow Triggers At The Wrong Time (Schedule Notification) (Doc ID 1994538.1)

Last updated on AUGUST 30, 2016

Applies to:

Oracle Fusion CRM Application Composer - Version and later
Oracle Fusion CRM Application Composer Cloud Service - Version and later
Information in this document applies to any platform.


On : version, Customer Center and Common

User setup a bunch of workflows which sends out emails. The workflows has Execution Schedule set up.
There are 3 workflows which sends out emails to the users which based on a custom Field (Renewal Date).
The email is sent 365 days, 180 days & 90 Days prior to the Renewal Date.


The problem is when user sets the Renewal Date 3  months from now, i get wrong the emails (the one for 12 months, 6 months) & i don't get the email for the one which i am suppose to receive (3 months).
This is the same problem when i test with Renewal  Date 6 months from now, i receive the email for 12 months & not for 6  months.

User expect to get only the email for 3  months when renewal date is set at 3 months later than sysydate
and not 6 months and 12 months ones

The issue can be reproduced at will with the following steps:
1.Navigator > Customize > Application Composer > Sales application > Workflow > create workflows for Opportunity object
- on creation - based on renewal date criteria  (In 3 Month , 6 Months 365 days) for notification email
- on update - based on renewal date criteria  (In 3 Month , 6 Months 365 days) for notification email

2. i user  update SR with a date of 3 months in the future > get notification  email for 6 months 12 months and not for 3 months
same behavior on Opportunity creation or update

The issue has the following business impact:
Due to this issue, users cannot receive notification for the wished period / gap only (eg 3 months)


To view full details, 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 a vibrant support community of peers and Oracle experts.