Popular Tags
- OTBI 1,446
- Reporting 1,392
- FDI 1,116
- Analysis and Data Visualization 986
- BI Publisher 854
- Analysis 682
- Oracle Fusion Analytics 585
- Administration 555
- OAC 449
- OBIEE 433
- Analytics 399
- BI Publisher Data Models 356
- Security 293
- HCM 266
- Answers 264
- BIP 263
- Analyses 255
- Developers 245
- Data Modelling and Datasets 228
- Data Connectivity 210
- ERP Analytics Content 208
- BI Publisher Report Templates 204
- Oracle Analytics Cloud 192
- Report Output 184
- Fusion Data Intelligence 179
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
-
Oracle FDI - Resume/Profile Matching with Open RequisitionsFor resume screening based on current open requisitions for Oracle Recruiting Analytics in FDI, Do we have any available subject areas or charts in FDI? like profile or … -
Oracle FDI – HCM securityHello Everyone, We have a requirement to restrict all access to C-Level executive data (e.g., CEO, CFO, CHRO, etc.) within Oracle Fusion HCM FDI Analytics. This restrict…
-
Locate Offer SalaryHi, For the context, we are using HCM 25A. I'm trying to query the offer salary amount in the job offer. I have checked IRC_OFFERS, and it doesn't contain the informatio…
-
BI Publisher Reports pulling blank and/or timeout errors with no modifications doneWondering if anyone has run in to similar situations. We have custom SQL/BI Publisher Reports that are encountering unexplained issues. For example reports that have bee…
-
How do I get the Public holidays details in FDIOne of my requirement to calculate working days. for that, I need to exclude week ends and public holidays. But, In FDI, I don't know, where to get that public holiday d…
-
Users can't see data or only their informationHi Experts, We are experiencing a very unique issue. Out users can't see data or only their information. We validated that there are no security assignments at user leve…
-
Facts columns are missing in local subject area HCM - Diversity AnalysisI am not able to see fact values under HCM - Diversity Analysis . when I try to add the annualized full time salary, then data is not visible Example 2 : after adding Fa…
-
How to create a date from a period field in OAC Dataflow (function DATE not available)Hello everyone, I’m currently working in the Dataflow menu of Oracle Analytics Cloud (OAC). I’m trying to transform a period field that I derived from dates, in order to…
-
Using data Validation feature, when there is a mismatch of counts how to get the OTBI queryNewly configured Data validation feature and we are successfully able to get Detailed validation and scheduled validations. For some of the metrics when we were doing De…
-
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,…
-
Create infolets with the use of FDI reportsHello, We have been implementing the new reporting tool of FDI and we have been asked if it is possible to create Infolets for the FDI reports in the home page of Oracle…
-
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