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
Where AI meets business outcomes Oracle AI World brings the Oracle community together to explore how AI and other technology innovations are driving real business outcomes across industries. Discover what’s new through: Mainstage keynotes to hear the latest directly from Oracle leadership Product demonstrations Customer…
HI, I am trying to get data from the Enterprise Contracts - Contracts subject area in FDI. However, it is not returning any records when I use this subject area. Are there additional configurations or setup tasks needed to pull enterprise contracts data in FDI? I have checked the following: In Oracle fusion, I have access…
How to Inject external data (Business central data) into Oracle Autonomous lakehouse via SFTP connector in FDI?
OOTB subject area fields are not available in DEV and PROD. Existing workbooks display "Error Loading Data" and report that standard fields are cannot be found. Local Subject Areas also display "Schema listing not available". The issue appears to affect the FDI semantic layer/metadata across environments. Can anyone facing…
I’m currently facing an issue with the Absence data in FDI. For example, in the screenshot, the Approved Absence measure is showing 1, while the correct value in Fusion 1,560. A few points: This is the standard/prebuilt dashboard; no customizations were made. There is no date filter applied. The FDI refresh runs daily, so…
Report 1 :We do have FRS report with 7 to 8 columns.HTML veiw of the report showing extra space .how to fit the output to the report .There should not be space in the html report.Attaching the report output. Report 1 output : Report2 : We do have an FRS Report where one connection has all ledgers except CSG IND STAT…
