What's new in Customer Journeys?

Connect and learn more! ×
Custom Resource Alert - Exited Waitlist Filter — Cloud Customer Connect
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

Custom Resource Alert - Exited Waitlist Filter

Received Response
47
Views
2
Comments
edited Jan 31, 2024 2:55PM in Learning 2 comments

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!

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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