Data Applications → Oracle Cloud Human Capital Management

Learn how this data application helps meet your business goals.

Overview

Incorta's pre-built content for the Oracle cloud Human Capital Management (HCM) module provides prebuilt schemas, dashboards, and insights for the areas of Core HR, Recruiting, Payroll, Leave & Absences, and Learning to help you easily monitor and analyze your organization’s human resources to manage your resources better. Human Capital Management analysis takes many shapes. From recruitment to core HR to variance analysis across the many dimensions of the organization. The ability to go from top-line results to a singular or collection of contributing transaction(s) is the heart of that analysis.

For business benefits, refer to the data application on Incorta.com.

This data application includes customizable dashboards and metrics for these business flows:

  • Human Resources
  • Projects

Requirements

Before configuring this data application, your Oracle Cloud ERP administrator must create a single user with access to the Oracle Cloud ERP Business Intelligence Cloud Connector (BICC) and Universal Content Management (UCM). The Oracle Cloud ERP BICC URL must be accessible by Incorta.

For instructions, refer to the Create BICC user and assign roles and Create UCM user and assign roles in the Oracle Help Center.

Available Schemas

Below is a list of the physical and business schemas in Incorta available after you install the data application:

Physical SchemaBusiness Schema
FusionHRAbsence_TimesheetFusion_HCM
Fusion_CAL_COMMON
FusionHRLearningFusion_HCM_Learning
Fusion_HCM
FusionHRPayrollFusion_HCM
Fusion_CAL_COMMON
Fusion_HCM_Payroll
FusionHRRecruitingFusion_HCM
Fusion_CAL_COMMON
Fusion_HCM_REC
FusionHRWorkforceFusion_HCM
Fusion_CAL_COMMON
Fusion_HCM_REC

Available Dashboards

Below is a list of the dashboard in Incorta available after you install the data application in the Oracle Cloud ERP Data App folder:

Folder nameDashboard nameInsight name
4- Cloud Human Resources/Core HR0. Recruitment Analysis
  ●  Active Recruitment Funnel
  ●  Application Sources
  ●  Hires by Job Type
  ●  Monthly Metrics
  ●  Open Reqs by Org
  ●  Reqs Summary
  ●  Reqs Trend
  ●  Responses by Application Sources
  ●  Submissions Summary
4- Cloud Human Resources/Core HR1. Workforce Overview
  ●  Active Workers
  ●  Employees By Gender
  ●  Managers By Gender
  ●  Terminated Workers
  ●  Terminated Workers by Action
  ●  Worker Hierarchy
  ●  Workers By Age
  ●  Workers By Tenure
4- Cloud Human Resources/Core HR2. Workforce Quarter Trends
  ●  Attrition Summary
  ●  Attrition Trend
  ●  Contingent Worker By Qtr
  ●  Employees By Qtr
4- Cloud Human Resources/Core HR3. Workforce Quarter Turnover
  ●  Quarterly Turnover %
  ●  Turnover Summary
4- Cloud Human Resources/Core HR4. Compensation Overview
  ●  Average Salary By Org/Gender
  ●  Details
  ●  Salary By Age Band/Gender
  ●  Salary by Gender
  ●  Salary By Grade
  ●  Salary by Location
  ●  Salary By Org
  ●  Salary By Top 20 Jobs
  ●  Supervisor Hierarchy
4- Cloud Human Resources/Core HR5. Compensation Trend
  ●  Salary Trend By Job Function
  ●  Salary Trend By Org
  ●  Salary Trend By Year/Month
  ●  Trend by Gender, Age and Salary Band
4- Cloud Human Resources/Core HR6. Compensation - KPI's
  ●  4 Year Salary Trend
  ●  Salary - Compression Between Jobs
  ●  Salary - Compression within Grades
  ●  Salary Percentile
4- Cloud Human Resources/Learning1. Learning Overview
  ●  KPIs
  ●  Mandatory Courses
  ●  Top 10 Completed Training in last 60 Days
  ●  Top 10 Overdue Training in last 60 days
4- Cloud Human Resources/Leave and Absences1. Absence Overview
  ●  Absence Details by Status - Contingent Worker
  ●  Absence Details by Status - Employees
  ●  Absence Status - Count
  ●  Absentee's by Location and Department
  ●  Absentee's Distribution by Location, Department, Job Family, Job, and Grade
  ●  Supervisor Hierarchy - Absence Duration
  ●  Worker Hierarchy - Absentee Count
4- Cloud Human Resources/Payroll1. Payroll Balances Overview
  ●  Details
  ●  Payroll Balances by Business Unit
  ●  Payroll Balances by Category
  ●  Payroll Balances by Department
  ●  Payroll Balances by Job
  ●  Payroll Balances by Location and Grade
  ●  Payroll Balances Monthly Trend
  ●  Payroll Balances Monthly Trend Details
4- Cloud Human Resources/Payroll2. Payroll Run Results Overview
  ●  Average Base Salary
  ●  Average Monthly Rent
  ●  Labor Cost
  ●  Labor Cost Details
  ●  Payroll Element Register Report
  ●  Payroll Run Results by Department
  ●  Payroll Run Results by Department/Manager
  ●  Payroll Run Results by Location
  ●  Payroll Run Results Details
  ●  Payroll Taxes
4- Cloud Human Resources/Payroll8. Payroll Flow Details
  ●  Payroll Flow Details
  ●  Total Task By Flow Status
  ●  Total Task By Task Status