Alerts not being sent

Summary:

Content (required):

Hello,

I was wondering if anyone had any advice on the below Learning Alerts we have created.

We have created Learning Alerts for 'Exited Wait-list' and 'Required Learning Expiration Approaching':

and used the following conditions:

Exited Wait-list:

${assignmentStatus} = 'ORA_ASSN_REC_ACTIVE'

exists (SELECT 'x' from dual where ${exitedWaitlistDate} >= (select nvl(max(runs.run_end),sysdate-1) from hrc_alert_runs runs, hrc_alerts_b alerts where runs.alert_id = alerts.alert_id and alerts.alert_code = 'INSERTED CODE'))

Required Learning Expiration Approaching:

${expirationDate} < sysdate + 31

${expirationDate} > sysdate + 30

${assignmentStatus} = 'ORA_ASSN_REC_COMPLETED'

${assignmentType} = 'ORA_REQUIRED_ASSIGNMENT'

However neither alerts are picking anyone up. We have moved someone off the waitlist today and also have a number of people who have learning expiring within the next 30 days, so we aren't sure why this is not working?