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
Hi, I'm new to OTBI & FDI and need your help. Is it possible to do a report to identify missing default expense account in FDI or OTBI? Thanks for your help.
Hi Team We are using SCM- Maintenance subject areas for reporting . We enabled the Asset related DFFs (CSE_ASSETS_B) under Data Configuration successfully but the Asset DFFs are not reflecting under Descriptive Flexfield Folder . We do not see any Asset folder even under the Descriptive Flexfield folder . Please advise if…
We made some changes in the Fusion UI, and those changes were reflected correctly in OTBI but not in FDI. To refresh the data in FDI, the Oracle support team advised me to reload the relevant functional area (Absence Management). I navigated to Application Administration → Human Capital Management, selected Absence…
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?
In an analysis/report, when the Bottom Up Manager details are selected from the hierarchy, the Top Position Person record drops out. This is due to the fact that this top level position does not have a record in the Fusion table : PER_MANAGER_HRCHY_CF which is the source to load OAX$OAC.DW_MANAGER_CF_DH . The requirement…
