because (I'm guessing) your escalation points are set to "repeat", each time the evaluation occurs and the age is below the threshold, it repeats. We have an Oracle DB, so in our environment we've solved similar problems by putting an Escalation Point Condition in, something similar to:
trunc(renewaldate) - trunc(sysdate) = 90 ... that way, the condition will only evaluate to TRUE on THE DAY where it's exactly 90 days out.
and you'd do the same for the 60 and 30 day points
------------------------------
Jade Warren
Great River Energy
------------------------------
Original Message:
Sent: 11-01-2022 09:41
From: Shannon Stommel
Subject: Escalation with Multiple Escalation Points
Thank you!
This does work for the email not being sent 3 times if the contract is in the 90 days, but it looks like once an email is sent once when the contract is in the 90 days it won't send it again when it reaches the 60 days escalation. Not sure if a flag is set telling the escalation not to send another email on the contract. I can revise the contract and add a new date in which then does fire another email.
Is there a way for the email to be sent multiple times when it reaches the 90, 60 and 30 day escalation points if the renewal date does not change?
------------------------------
Shannon Stommel
Insteel
Original Message:
Sent: 11-01-2022 08:59
From: Steven Shull
Subject: Escalation with Multiple Escalation Points
You'll need to add additional logic to the escalation points to filter out the 90 and 60 day escalation points when the contract expiration is significantly less than the current date.
For example, right now the 90 days is determining if renewaldate < sysdate+90 for example. What you could do is in the escalation point is add an additional condition that the renewaldate>sysdate+60. That way that will only send when it's some amount between 90 and 60 days. In the 60, you'd do something similar but check for sysdate+30.
------------------------------
Steven Shull
IBM
Original Message:
Sent: 10-31-2022 15:34
From: Shannon Stommel
Subject: Escalation with Multiple Escalation Points
Hello!
I created an escalation to send an email when a contract renewal date is 30, 60 or 90 days away.
I have 3 Escalation Points, one for when the renewaldate is -90 days, one for -60 days and one for -30 days. The only problem is when a contract has an expiration date of 20 days, I am receiving 3 emails, one from each escalation point. A contract with 80 days is only sending 1 email.
Is there another way to filter when the emails run?
I'm using the instructions from the following article: https://maximosecrets.com/2021/12/17/escalations%EF%BF%BC/
#MaximoApplicationSuite
------------------------------
Shannon Stommel
Insteel
------------------------------