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 11.1.9.2.0 and later
Oracle Fusion CRM Application Composer Cloud Service - Version 11.1.9.2.0 and later
Information in this document applies to any platform.

Symptoms

On :  11.1.9.2.0 version, Customer Center and Common

ACTUAL BEHAVIOR  
-----------------------
1)
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.

2)

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.



EXPECTED BEHAVIOR
-----------------------
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


STEPS
-----------------------
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

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

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