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

Shiva Prasad M

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

Sinduja Sekar-Oracle

Hi @Shiva Prasad M ,

Yes, the HCM - Workforce Core subject area will give data based on the effective latest change.

Please open a Service Request through My Oracle Support so we can better assist you with this request.

Regards,

Sinduja

Dhiren Gangani-Oracle

Hi Shiva & Sinduja,

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

Thanks & Regards,

Dhiren G.

RVohra

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!

Bhaskar Konar

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!