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

HR Action is not picking correctly

edited Mar 8, 2017 5:53PM in Reporting and Analytics for HCM 2 comments

Content

In the OTBI, I am creating a report to list all the terminated employees along with the HR action. Though I am using max(effective_start_date) "Workforce Management - Worker Assignment Event Real Time"."Assignment Event Details"."Effective Start Date" it is displaying 2 records out of which one is an older date.

Why I am not getting only the latest record. Do I have to use any other assignment dates to bring just the latest record?

I have aslo included the screen shot of my result and the query.

 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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