Absence alert sysdate filter doesn't — Cloud Customer Connect
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

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)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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