Data are synchronized with Oracle HCM and I can see PN 2470, which was terminated in the past.
If I add any assignment information I find no records, why?
Hi @Stefano_Mazzocca Workforce Core subject area has data from two tables. One is an active/suspended daily snapshot. In this, you will find the inactive workers only until the day they were active. For example: A person was terminated on 6-Sep. If you filter for any date on or before 6-Sep then you will find that worker record with status as Active. In this case, add the metric 'Headcount' from Workforce Headcount Facts > Facts - Workforce Headcount, and a filter on Time.Date as any date prior to the worker's termination.
The other table is, HR Event one. In this you will find all workers based on any HR event that they have had. In your example: in the report add the metric 'Assignment Event Headcount' from the folder Workforce Headcount Facts > Facts - Workforce Events. You do not have to add date filter in this query.
With this, your inactive person 2470 will show up
Thanks
Raghu
Hi @Stefano_Mazzocca When you create a report using any metrics from "Workforce Headcount Facts > Facts - Workforce Headcount" then automatically it will render only the active workers. So, it will exclude the inactive workers from it. If you can elaborate on your exact reporting requirement, i can assist you.
Hi @Raghavendra Raghunath-Oracle , so I added the month filter and the Headcount Fact, now I can see it but is there any way to exclude the headcount which is really not wanted for our purposes?
Description: The Oracle Fusion Data Intelligence (FDI) Product Roadmap Update provides an overview of the latest developments and future plans for FDI. Oracle Product Management experts will share upcoming capabilities, key enhancements, and product direction, helping attendees understand what is changing and how these…
How to show amount columns with currency symbol and format in AI Agent response. Provided sample in supplement instruction but it is not displaying based on format
After the recent Oracle FDI/OAC release updates, both our PROD and DEV environments no longer display the Data | Visualize | Present tabs at the top of the workbook.Previously, I used the Present tab to: Hide or show specific canvases/visualizations. Hide filters used in the workbook. With the new workbook interface, I…
We are trying to clarify the 2 data sets that go into the oracle-delivered "Headcount Turnover" measure. This measure is found in FDI, in "HCM - Workforce Core"."Facts - Workforce Headcount" subject area We have our own internal calculation, which is a few percentage points different than this measure, which is why we are…
My data: My Calculation - above in the last column you can see it works great: So why the heck my table goes blank for every value in Month End Date filter?
Dear Experts, We are trying to add security steps to our new implementation but the option that is mentioned in oracle documentation and also seen on other existing implementations is not available in our instance. The Navigation is FDI Console> Semantic Model Extensions> Security Configurations> Data Security Step.…
