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
Custom Resource Alert - Exited Waitlist Filter
Summary:
Hello experts!
I'm seeking recommendations on how I can ensure that I get the latest data every run of my scheduled hourly for the EXITED WAITLIST.
Tried using the filter in this file but it's not working: https://support.oracle.com/epmos/main/downloadattachmentprocessor?parent=DOCUMENT&sourceId=2786113.1&attachid=2786113.1:EXITED_WAITLIST&clickstream=yes
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 = 'PUT_ALERT_CODE_HERE')) ${assignmentStatus} = 'ORA_ASSN_REC_ACTIVE
Your insights would be greatly appreciated. Thanks a bunch!
0