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

Expiring training resource alert - filter out recertified records?

Summary:

We have a custom alert created to notify learners/team leaders of Required training that is about to expire in 30 days, here are our filters:

NOT EXISTS (SELECT 'X' FROM ANC_PER_ABS_ENTRIES WHERE 1 = 1 AND PERSON_ID = ${ assignedToId} AND ABSENCE_STATUS_CD NOT IN ('ORA_WITHDRAWN','SAVED') AND APPROVAL_STATUS_CD IN ('APPROVED') AND ${AlertFilterUtils.getCurrentDate()} BETWEEN START_DATE AND END_DATE)

trunc(${expirationDate}) = ${AlertFilterUtils.addDays(AlertFilterUtils.getCurrentDate(),30)}

The issue we're running into is that if this user has a renewal assignment created through an initiative, then it's very possible the team member will have already completed the training a second time (before the expiration date), and still recieve this email alert.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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