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

Alert for Completed with the EXIST clause

edited Jun 28, 2021 1:22PM in Learning 2 comments

Content

Hi there

We use the EXIST clause for enrollment notifications

exists (SELECT 'x' from dual where ${assignmentCreatedDate} >= (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 = 'C2E88D2D4DFED79BE0530860750AD2C2'))

 I combine it with the statuses

${assignmentStatus} <> 'ORA_ASSN_REC_WITHDRAWN' AND ${assignmentSubStatus} <> 'ORA_ASSN_REC_WITHDRAWN' AND ${assignmentStatus} <> 'ORA_ASSN_REC_COMPLETE' AND ${assignmentSubStatus} <> 'ORA_ASSN_REC_COMPLETE' AND ${assignmentStatus} <> 'ORA_ASSN_REC_BYPASSCOMPLETE' AND ${assignmentStatus} <> 'ORA_ASSN_REC_DELETED'

it works well.

I wonder if one can use the EXIST clause for a Completed message? if yes, i guess one should not use the " ${assignmentCreatedDate}" but completedDate?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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