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 with Redwood for Oracle Cloud HCM   Begin Now

Why this Alert for Learning module doesn't work?

Received Response
81
Views
2
Comments

Summary:

Alert does not retrieve data.

Content (required):

I made a custom alert, the only filter I used is the one below (see also "Code Snippet" section).


Recipients are these (I tried every possibility):

If I try the condition on BI Publisher the query returns data but this alert don't:

Result: I don't get any notification when assigned to a course.

What could it be?

Version (include the version you are using, if applicable):

23B

Code Snippet (add any code snippets that support your topic, if applicable):

exists (SELECT 'x' from dual where ${assignmentCreatedDate} >= (select max(trunc(sysdate)) from hrc_alert_runs runs, hrc_alerts_b alerts where runs.alert_id = alerts.alert_id and alerts.alert_code = '026336D7F5550261E063A096410A037A'))

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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