Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 42 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 277 Oracle Analytics and AI News
- 48 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 19 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
How to fetch history data for an employee through HCM - Workforce subject area
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
Answers
-
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
0 -
Hi Shiva & Sinduja,
We are also having similar requirements. Any resolution came for this kind of scenario.
Thanks & Regards,
Dhiren G.
0 -
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_idHope it helps!
0 -
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!
0
