How to fetch history data for an employee through HCM - Workforce subject area

Question

Hello Team,

Client has a requirement to check on month on basis where there was a change in Department, he would like to see the history of changes with respect to department change for an employee.

All effective dated rows of the employee.

However, HCM core subject area is always giving the latest effective dated row only.

Thanks,

Shiva

Bhaskar Konar · Answer

https://community.oracle.com/products/oracleanalytics/discussion/comment/73367#Comment_73367

Hi @Dhiren Gangani-Oracle,

Please raise your query as a new question as this thread is almost 2 years old and might not be helpful for getting the solution.

Thank you!

RVohra · Answer

You can see if it is possible thru BIP query,

SELECT

….

FROM per_all_people_f p JOIN per_all_assignments_f a

ON p.person_id = a.person_id

JOIN hr_all_organization_units_f d

ON d.organization_id = a.organization_id

Hope it helps!

Dhiren Gangani-Oracle · Answer

Hi Shiva & Sinduja,

We are also having similar requirements. Any resolution came for this kind of scenario.

Thanks & Regards,

Dhiren G.