Forum Stats

  • 3,853,148 Users
  • 2,264,184 Discussions
  • 7,905,266 Comments

Discussions

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

User_2K8XG
User_2K8XG Member Posts: 1 Green Ribbon

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?

Tagged: