Hello Experts,
I am having issue while working with HCM - Workforce Core in which I am using Person Number and Department Name. The value getting is not in line with the data in my fusion environment.
Please guide what I am missing.
26C.
Hi @SaurabhPSingh
Add the metric 'Headcount' to this report.
Also, can you explain what do you mean by this below statement with a screenshot
'The value getting is not in line with the data in my fusion environment.'
Thanks
Raghu
Hi @SaurabhPSingh ,
As per your screenshot, it seems you have not applied any filters. This would mean you are pulling all person numbers, not just your currently active workers.
Hi @Raghavendra Raghunath-Oracle ,
I meant the output is showing very few employees as compared to my data available for Person Number and department. I am not sure why this issue is appearing. Adding Headcount gives below result
@Orange : There is no filter applied and I am expecting all Person Number and department name in the output.
Regards
Saurabh
Hi @SaurabhPSingh Can you add 'Headcount' metric to this query
This is the result after adding Headcount to the query.
Weird, it is showing only 5 rows. Thinking is it something to do with some security.
Hi @SaurabhPSingh Yes, this is got to do with your security setup, You can run similar queries in other subject areas also to see if the data rendered is consistent.
It is the same behaviour on for all the subject areas. As far as roles in Oracle Fusion environment , I have almost all the HCM roles. I have no issue in running my OTBI report.
But here in Analytics Cloud, I am having issue.
Can you guide me to the items that needs to be checked from security to run these in Analytics Cloud ? I will check with OCI team if possible.
Hi @SaurabhPSingh it depends on what data security that you have in FDI. You need to let us know which groups you have access to? and what application roles you have
From the Security screen > User tab - filter for your user name
you get the groups to which you have access
using that filter for the group in the Groups tab - filter for all the data roles
As an alternative, provide yourself with 'Human Resource Analyst' group in FDI and re-test the same reports
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.…
