Popular Tags
- OTBI 1,456
- Reporting 1,398
- FDI 1,146
- Analysis and Data Visualization 991
- BI Publisher 865
- Analysis 684
- Oracle Fusion Analytics 597
- Administration 557
- OAC 481
- OBIEE 434
- Analytics 410
- BI Publisher Data Models 360
- Security 299
- HCM 269
- BIP 265
- Answers 265
- Analyses 255
- Developers 246
- Data Modelling and Datasets 229
- Oracle Analytics Cloud 219
- ERP Analytics Content 215
- Data Connectivity 212
- BI Publisher Report Templates 205
- Fusion Data Intelligence 196
- Report Output 184
We are moving this forum's discussions to a new location. During this transition, this forum will become read-only starting 15th January 2026. For any new questions, please email us at analytics-community-ww_mb@oracle.com. Thank you for your understanding and continued participation!
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Oracle Fusion HCM Analytics
Ask questions about Oracle Fusion HCM Analytics, the prebuilt cloud native solution for Oracle Cloud HCM. Get answers from human resource professionals on employee attrition, retention, talent acquisition and management, compensation, workforce diversity, and more.
Discussion List
-
Query to find pay period and Hours Worked, separating out PTO vs ESL vs FMLA hour groupsCan someone please help with a Oracle Fusion SQL query to find pay period and Hours Worked, separating out PTO vs ESL vs FMLA hour groups. I found the attached as a star… -
How to Identify relative column on OTBI side for an FDI ColumnTrying to test latest release updates on Oracle HCM . HCM - Talent Acquisition subject area has these enhancements: New Metrics - New metrics related to openings filled,…
-
OAC/FDI preview feature "Salary Basis Snapshots" troublewe are on the most recent release in OAC/FDI (25.R3.P1) and enabled the feature "Salary Basis Snapshots". I believe the feature was turned on correctly as I now see the …
-
Organization Hierarchy Availability in HCM Subject AreasOrganization Hierarchy is available in most HCM subject areas, however, it is not included in the Learning (generally available) subject area. Will this be available in …
-
How to show Indirect reportees to custom Line managerWe have configured custom line manager and custom HR role as mentioned in the blog below Setting Up Custom Human Resource Analyst and Line Manager Data Security Access (…
-
Ability to connect from FDI to Private endpointWe have an oracle database in another tenancy than the one where our FDI is. Could we create a connection to that database from FDI? The target is private DB
-
Oracle FDI- Profile Matching with open requisitionsI am looking to build recruiting analytics for candidate profile/resume matching with open requisitions in oracle FDI. Please suggest any inputs to build. I don't find s…
-
SQL to get individual compensation plan items to show under Additional compensationI want fetch Additional Compensation details for Individual Compensation plan through SQL. below is the screen I want to query. Person will have multiple plan and option…
-
Not receiving totalResults value while using filter in /hcmRestApi/scim/Users restAPIWe tried using the below query: https://hctz-dev2.fa.us2.oraclecloud.com/hcmRestApi/scim/Users?totalResults=true&filter=(active eq true) to find all the active users in …
-
How can we calculate total Off Cycle Payments using the standard columns available in HCM SAHow can we calculate total Off Cycle Payments using the standard columns available in HCM SA
-
How can I calculate total payroll expenses using the standard columns available in HCM Payroll subjecan you please help me. How can I calculate total payroll expenses using the standard columns available in HCM Payroll subject areas?
-
How can we calculate total payroll error raTE using the standard columns available in HCM SAHow can we calculate total payroll error rate using the standard columns available in HCM Payroll subject areas?
-
Incremental Load Option for HCM subject areasCurrently we see once in a day (24 hours delay) for incremental load for HCM Analytics/subject areas. mainly if 24 hours delay the users can't adopt, mainly for current …
-
Need help building a Hires report from Workforce Core and Talent Acquisition subject areasFor compliance reporting purposes, we've built a hires report that includes data from both the HCM - Workforce Core and the HCM - Talent Acquisition subject areas. The p…
-
FDI DataFlow - Data RefreshI have a dataflow created based on FDI dataset. When I run the dataflow, it is progressing as "Running" . In case I refresh the page, the refresh process status does not…
-
Talent 9-box visualizationHi all, We cannot find the 9-Box assignment in FAW (it's n-box but 9-box is well-known). We have checked in subject areas: HCM - Workforce Core HCM - Talent Review Meeti… -
REST API to access oracle analytics cloud workbook output data to show the number on ODA screenHello Team, We have a requirement to show headcount or exits etc., output on ODA screen. We explored to see if there are any REST API available to fetch the output data.…
-
HCM workbook showing workers in one department with old department tree information.I have a FDI workbook with worker and department tree information and for one current department it is showing older tree version data that is current. The department wa…
-
Payroll ValidationDoes anyone have a way that they validate payroll in FDI compared to fusion? Recently we've ran into issues where payroll SA's in FDI do not tie to fusion. We've worked …
-
Configuring EEO-1 Establishment Electronic ReportWe're interested in using this report: EEO-1Establishment Electronic Report. Before the report can be generated, the following information must be configured. Locations …