Skip to Main Content

How to get future dated hires in OTBI report which is running as of sysdate?

User_2K8XGAug 9 2022

We have a requirement of showing future dated hires in the output of an OTBI report which is running as of sysdate. Basically we need all the employees who are active as on today along with the future hires for the next 7 days. We are using the "Workforce Management - Worker Assignment Event Real Time" area for this report.
Using the SQL prefix SET VARIABLE PARAM_EFFECTIVE_DATE= future date, we can run the report as on a future effective date. One probable solution was to run the report as on sysdate + 7. But that way, the report will exclude the employees who are active today but terminated within the next 7 days.
So is there any way to get a list of all the employees who are active today along with those who will be hired in the next 7 days using an OTBI report?

Comments
Post Details
Added on Aug 9 2022
0 comments
41 views