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

Using OTBI to fetch latest ACTIVE assignment

Accepted answer
edited Jun 26, 2023 12:26PM in Reporting and Analytics for HCM 8 comments

We would like to use a filter which we can re-use to fetch the latest active assignment for a person.

For 99% of our population, it works to do MAX("Worker"."Assignment Number" BY "Worker"."Person Number"). However, for one of our workers it's not giving the correct result. This case is a bit exotic, because the worker has had multiple global transfers and a split assignment/payroll. He now returned to his original assignment (the split assignment is changed back from 0.1 to 1.0 FTE) and the 'newer' assignment was terminated.

I found this topic, but I got the same result from that setup.

Howdy, Stranger!

Log In

To view full details, sign in.


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