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
Get Started: AI 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

edited Sep 1, 2020 4:30PM in Learning 1 comment

Summary

Creating Alert for Cancelling Scheduled Training Learning Are Enrolled In

Content

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'))

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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