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
Alerts Composer - SQL query
Summary:
We have a requirement where we are adding contract end date in the field of 'Projected End Date' for contingent workers.
In case where contract needs to be extended, the managers need to be alerted that the contract end date is reaching soon, and it needs to be extended.
And for the ones where we are absolutely sure about the contract end date, we are adding a Termination record for them on a future date.
So, how do we configure a filter in alert where we send notification/alert to the manager on the basis of Projected end date entered in the maximum assignment record with ACTIVE status ? I see that in the SQL, functions like MAX does not work, neither ORDER BY EFFECTIVE_END_DATE DESC works, nor subquery works.
0