Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Creating Alert for Cancelling Scheduled Training Learning Are Enrolled In
Summary
Creating Alert for Cancelling Scheduled Training Learning Are Enrolled InContent
Hello, I'm trying to create an alert for a cancelled activity that's scheduled in Learning.
To cancel, I'm following:
Step 1: Put a publish end date to learning item
Step 2: Select all the enrolled learners who are In Progress or Not started status and choose action as 'Withdraw'
Here is the current alert I have setup, but it's not triggering any notifications.
LearnerLearningRecord
${assignmentStatus} = 'ORA_ASSN_REC_DELETED'
${reasonCode} = 'ORA_SEPC_DEL'
exists (SELECT 'x' from dual where ${assignmentLastModifiedDate} >= (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 = 'A5798C6457F46637E053847F230A407B'))
0