Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Alert composer: Retrieving data for next 3 months from current date is not working
Summary:
Hello we have a requirement to trigger a probation alert 3 months prior before the end date.
We have created a sql query to test the data first before we move to create the filter.
See below screenshot where we used sysdate + 90.
If we run the query today, we're getting data of probation which will end next month which its wrong. We should get data for next 3 months which will records for october only.
Please advice on how to resolve so that we get exact data for the next 3 months.
Thanks
Content (required):
Version (include the version you are using, if applicable):
0