You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Can we use all operators (=, >,

edited May 21, 2020 7:51AM in HCM Integrations

Summary

Custom Alert not working with some operators in the expression filer of the custom alert with DFF date attribute

Content

Hello

I am using a DFF Date Attribute in the Custom Alert.

In the Expression Filter, when I try to use the condition as  "****_ATTRIBUTE_DATE5 = sysdate+14" or "****_ATTRIBUTE_DATE5 >=sysdate+14" or "****_ATTRIBUTE_DATE5 BETWEEN sysdate+14 AND sysdate+16", the alert does process successfully but does not send out any alerts to the recipients (Alert Log also does not show any), where as the condition "****_ATTRIBUTE_DATE5 BETWEEN sysdate and sysdate+14" work appropriately and the messages are sent too.

My requirement is to check the condition of sysdate+14 only on the DFF Date Attribute and send out an alert.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!