Absence alert sysdate filter doesn't
Summary:
We are trying to create an alert to notify users of compensatory expiration. Please suggest what am I missing here.
- Alert composer filter using sysdate does not work. I have attached the doc with snapshots. We have tried same filters with absence, emp and planbalances resource as well. A simple SQL also doesn't work.
- We have tried the following:
- $(expiryDate) >=sysdate
- ${expiryDate} >= ${AlertFilterUtils.getCurrentDate()}
- EXISTS (SELECT * FROM ANC_PER_ACRL_ENTRY_DTLS WHEREpl_id=300000015433662AND TYPE IN ('ORA_ANC_COMPTMEADJ','ORA_ANC_COMPTME') AND trunc(EXP_DT) >=sysdateAND PERSON_ID=${PersonId})
- EXISTS (select 1 from PER_ALL_ASSIGNMENTS_M T1, ANC_PER_ACRL_ENTRY_DTLS T2 WHERE T2.pl_id=300000015433662 AND T2.TYPE IN ('ORA_ANC_COMPTMEADJ','ORA_ANC_COMPTME') AND T1.ASSIGNMENT_ID=300000019116970 AND T1.ASSIGNMENT_ID=T2.ASSIGNMENT_ID AND TRUNC(T2.EXP_DT) >= TRUNC(SYSDATE) AND SYSDATE between T1.EFFECTIVE_START_DATE and t1.EFFECTIVE_END_DATE)
Tagged:
0