Popular Tags
- OTBI 1,432
- Reporting 1,386
- FDI 1,087
- Analysis and Data Visualization 981
- BI Publisher 844
- Analysis 676
- Oracle Fusion Analytics 579
- Administration 555
- OBIEE 432
- OAC 426
- Analytics 395
- BI Publisher Data Models 350
- Security 291
- Answers 264
- HCM 257
- Analyses 254
- BIP 253
- Developers 244
- Data Modelling and Datasets 226
- Data Connectivity 211
- ERP Analytics Content 208
- BI Publisher Report Templates 204
- Report Output 184
- Oracle Analytics Cloud 177
- Customizing Reports 159
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,…
-
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…
-
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…
-
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 …
-
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…
-
FDI HCM: Employee Help Desk in Fusion AnalyticsEmployee Help Desk appears in the current column of the Fusion Analytics Roadmap. where can we find more information on this module? Victor -
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…
-
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 - 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- 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 …