Email Notification gets triggered twice

[vidhya_mouli]

I have a email notification which gets triggered, when the sc_req_item state becomes either closed complete, closed incomplete or closed skipped.

This notification gets triggered twice:

When I checked the event log, I notice that the sc_request gets updated twice.

Can someone explain why this is happening and how to resolve this?

[Prince Arora]

@vidhya_mouli 

There might be a After-business rule on the sc_req_item table in which "current.update()" is present, Please take a look as it executes the update twice

Steps:

1) Go to sc_req_item table

2) Check business rules on it

3) Check "*current.update" in script filter, if it is present then it is the only culprit

4) Disable it for sometime and try again.

If my answer solved your issue, please mark my answer as ✅ Correct & 👍Helpful based on the Impact.

[vidhya_mouli]

These are the 3 tables that have current.update and none of them seems to cause this problem

[Luxo Nadappan]

Current. Update() might be the real issue here. But if you feel otherwise ,please try change the condition on notification to something like "state changes to "closed complete" .

Regards,

Luxo

[vidhya_mouli]

I tired changing the condition and still face the same issue. I know the problem is something is causing the Request State to change from Approved to Closed Complete twice. Not sure how to check which is causing this issue.