How to get the last incumbent date for vacant positions

Nivya M

Hi Experts,

Looking for a sample report to get whether the position ever had an incumbent and if so what the last date the position was filled. I have been able to get which positions are vacant, but not able to find when the position got vacant

Regards,

Nivya

RVohra

You should explore following Subject Areas

Workforce Management - Assignment Action Occurrence Real Time

Workforce Management - Position Real Time

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/27750/how-to-get-the-last-incumbent-date-for-vacant-positions

Hi Nivya,

You can write a query based on per_all_assignments_m position_id. Get the latest effective start date from assignments table when a position was assigned.

Thanks.