Introduction

Overview

Oracle Fusion HCM Analytics is a prebuilt cloud native warehouse-based analytics solution built on top of the HCM Cloud application.

It provides human resource professionals with ready-to-use workforce insights to improve their decisions related to workforce diversity, employee attrition and retention, talent acquisition, compensation, and more. HR teams can enrich their analytics beyond what Oracle Cloud HCM provides with additional data sources by extending the single, cross-functional data model and pipelines, and end user metrics without coding. See Oracle Fusion HCM Analytics.

This guide contains information about data warehouse tables and entity relationship details for Oracle Fusion HCM Analytics. The guide covers these details for subject areas:

Job-specific Groups
Duty Roles
Associated Business Questions
Metric Details
Descriptive Flexfields

The guide also contains information on prebuilt analyses, prebuilt business metrics, and prebuilt dashboards.

Features Available for Preview

Preview features enable functional administrators to switch functionality on and off. This way, your organization can evaluate and learn how to use new features before they roll out by default.

To enable the preview features, see Make Preview Features Available.

Functional Areas

Feature	Description
Diversity Analysis	This feature enables the Diversity Analysis offering. Note: You must first enable the Diversity Analysis Prerequisites functional area and only then enable the Diversity Analysis functional area. The Diversity Analysis Prerequisite functional area gets the information needed for further processing and calculations that happens in the Diversity Analysis functional area.
Health and Safety	This feature provides information about the workforce health and safety incidents. This includes the details related to incidents, events, and actions.
Learning Management	This feature enables the Learning Management offering.
Salary Basis	This feature enables the Salary Basis offering.
Seniority Dates	This feature enables reporting on V3 seniority dates. It provides information of worker's seniority across the enterprise, various work relationship, and assignments. Worker's seniority across all rules are available for reporting using this. You can also report on the seniority rule setup.
Time and Labor	This feature enables the Time and Labor offering.

Pipeline Features

Feature	Description
Disable HCM Data Consistencies and Logging	This feature provides the ability to enable and disable HCM Data inconsistency logging and record rejection.

Features Generally Available

Oracle Fusion Analytics Warehouse offers certain functionality as generally available that you must enable using the Console. Generally available features are publicly available features that you can use for production workloads. These features enable functional administrators to switch functionality on and off and are disabled by default.

To enable the generally available features, see Enable Generally Available Features.

Functional Areas

Feature	Description
Payroll Balances	This feature enables the Payroll Balances functional area. It provides insights into payroll balances at person level and cumulative balance values across dimensions. Note: Before enabling the Payroll Balances functional area, you must enable the Workforce Core functional area and ensure that the required Cloud HCM balance group, Analytics Warehouse Balance Group, is set up. Payroll has been successfully implemented for customers with 90,000 employees. We recommend all customers to implement it as we continue to make it work for larger organizations.
Payroll Costing	This feature enables the Run Costing and Costing of Payment information in the Payroll Costing functional area. It provides insights into payroll run costing and costing of payment at person level and cumulative values across dimensions. Note: Before enabling the Payroll Costing functional area, you must enable the Workforce Core functional area and ensure that the Cloud HCM Cost Allocation Key Flex Field Label is set up and assigned to individual segments. Payroll has been successfully implemented for customers with 90,000 employees. We recommend all customers to implement it as we continue to make it work for larger organizations.

Feature

Description

Payroll Balances

This feature enables the Payroll Balances functional area. It provides insights into payroll balances at person level and cumulative balance values across dimensions.

Note:

Before enabling the Payroll Balances functional area, you must enable the Workforce Core functional area and ensure that the required Cloud HCM balance group, Analytics Warehouse Balance Group, is set up. Payroll has been successfully implemented for customers with 90,000 employees. We recommend all customers to implement it as we continue to make it work for larger organizations.

Payroll Costing

This feature enables the Run Costing and Costing of Payment information in the Payroll Costing functional area. It provides insights into payroll run costing and costing of payment at person level and cumulative values across dimensions.

Note:

Before enabling the Payroll Costing functional area, you must enable the Workforce Core functional area and ensure that the Cloud HCM Cost Allocation Key Flex Field Label is set up and assigned to individual segments. Payroll has been successfully implemented for customers with 90,000 employees. We recommend all customers to implement it as we continue to make it work for larger organizations.