Oracle Fusion HCM Analytics

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How do I validate the data across different FDI HCM subject Areas ?

Received Response
14
Views
1
Comments
User_N3X7K
User_N3X7K Rank 1 - Community Starter

Visualizations/KPI's

Workers with Absences

Absence Days

Absence Hours

Absences Days by Type

Absence Days by Legal Employer

Absence Details

Approved Absences

Pending Approvals

Rejected Absences

Withdrawn Absences

Which days have the most total absences each month?

Are workers with low performance rating taking more leave?

Where are most absences occurring?

How long are approved absences usually?

Top 10 managers with maximum absences availed

Approved Sick Leaves

Sick Leaves (Female)

Sick Leaves (Male)

Common reasons for sick leave

Total days lost due to sick leave

Where are most sick leaves occurring?

Male Gender Ratio (Approved Leaves)

Female Gender Ratio (Approved Leaves)

Female Gender Ratio (Rejected Absences)

Male Gender Ratio (Rejected Absences)

Absence Approvals/Rejections: Ethnicity Groups

Absence Approvals/Rejections: Religion Groups

Global Transfers

Internal Transfers

Gains Due to Reorganisation

Losses Due to Reorganisation

Top 5 - Popular Jobs By Internal Mobility

Top 5 Jobs - Worker Promoted

Top 5 Managers - Loss Of Workers

Promotions By Tenure Band

Global Transfers By Age Band

Career Path In An Organization

Headcount movement between Business units

Movement between Line managers

Total Journeys

Completed

Overdue

Avg. Days to Complete

Allocated vs Completed Journeys - Top 10

Allocated Journeys by Category - Top 5

Allocated Journeys Trend

Overdue Journeys - Top 5

Total Tasks

Completed

Overdue

Avg. Days to Complete Task

Planned vs Actual Time Taken (Days) - Top 10

Task Status

Worker Tasks - Allocated vs Overdue

Overdue Tasks by Type

Total Check-Ins

Managers with Check-Ins

Workers with Check-Ins

Check-In Details by Departments

How many check-ins have been completed each month?

Which managers have the most check-ins?

How many check-ins were scheduled with terminated workers?

Completed Appraisals

Pending Appraisals

Workers with Documents

Documents by Managers

Documents by Status

Performance Rating of Workers

Performance Tasks

Workers

Workers With High Performance

Workers with Active Profiles

Talent Ratings by Gender

High Performers by Gender

Top Competencies by Worker Profiles

Workers with Active Profiles

Risk of Loss Workers

Top Competencies

Top License and Certificates

Top Skills

Worker's Preferred Job Family

Career Move Preferences

Top Locations Preferences

Total Job Applications

No. of Applicants

Candidates with Disability

Avg Time to Hire (Days)

Job Application by Gender

Job Applications Progress

External and Internal Hire Rate

Job Application Sources

Total Openings

Total Job Applications

Vacancy Fill Rate (%)

Job Openings by Location

Vacancy Fill Rate by Year and Location

Offers Extended versus Actual Hires

Top 10 Requisitions By Applicant Count

Average Time To Fill (Days)

Average Time to Offer (Days)

Total Applicants

Time To Hire (Days) by Geography Name, Job Family

Time to Fill (Days) by Year and Quarter

Total Applicants by Hiring Phase

Time to Fill (Days) by Job Family

Total Requisitions with Applicants

Offer Acceptance Rate (%)

Number of Referral Applications

Total Applications by Job Family and Source Medium

Total Applications by Source Medium

Top 10 Sources by # of Applications

Number of Offers by Location

Active Plans

Plans without Candidates

Ready Now Candidates

Candidates by Gender and Ethnicity

Candidates - Potential vs Risk of Loss

Succession Plans vs Successful Plans Trend

High Risk Incumbents with and without Candidates

Internal vs External Candidates

Plans with and without candidates

Learning Completion Rate

Skill Development Index

Career Promotion Rate

Employee Growth

Employees with New Competency

Learning Enrollments Heatmap

Created vs Closed Incidents - by Reporter Type

Incidents by Evacuation Plans

Overdue Incidents by Severity

Incidents by Worker Years of Service

Incidents by Reporter's Age

Days to Close Incidents

Incident Events

Open Events

Avg. Days to Close

Total Events vs Open by Type

Average Days Open by Severity

Top 5 - Overdue Events by Type

Avg. Days to Close Events

# Investigations

Open Investigations

Days to Close

Created vs Closed by Investigation Type

Overdue Investigations by Type

Avg Days Since Open by Severity

YTD Incident Actions

Open Incident Actions

Closed Incident Actions

Corrective vs Preventive Actions Trend

Actions Priority

Number of Workers

Number of Required Skills

Number of Developed Skills

Number of Developing Skills

Largest to Smallest Supply Gap: Skills Demand and Supply

Smallest to Largest Supply Gap: Skills Demand and Supply

Total Earnings

Worker Count

Top 10 Jobs by Earning Distribution

Earning Distribution By Balance Category

Top 5 Jobs For Standard Earnings

Top 5 Jobs For Supplemental Earnings

Top 5 Jobs with Average Earning Across Genders

Standard Earning: Growth Trajectory

Supplemental Earning: Growth Trajectory

Standard Earning: Period To Date Accumulations

Supplemental Earning: Period To Date Accumulations

Average Cost per learner

Top Rated Courses

Top Courses That Enhance Learner Profiles

Current Learners by Performance & Potential

Course Enrollments vs Completions

Learner Demographics

Number of Learners

Distribution - Current Quarter(Head Count)

Turnover Percentage - Current Quarter(Workforce trends)

Promotions - Current Quarter(Work force Event)

Hires - Current Quarter(Work force Event)

Distribution Current by Month(Head Count)

Turnover Percentage by Month(Workforce trends)

Promotions by Month(Work force Event)

Hires by Month(Work force Event)

Leavers

New Hire Turnover

Hires. Leavers by Job Family

Hiring Details by Manager

Hires by Location

Top Talent Retent % - Current Quarter

Top Talents - Current Quarter

Worker without Rating - Current Quarter

Retention by Talent %

Top Talent

Retention % by Top Talent, High Potential, High Performer

Average Tenure Years

Contingent Workers

Top Performers

Worker Count by Job Family, Business Unit Name

Worker Count By Location

Compa-ratio By Job Family

Worker Count by Worker Type

Worker Count By Performance

Turnover By Month

Turnover By Business Unit, Gender

New Hire Turnover By Business Unit, Gender

Turnover by Age group, Gender

Turnover By Employee Ethnicity

Voluntary Turnover by Region

Turnover Details

Span Of Control by Job Function

Span of Control By Location

Span of Control By Job Function & Location Name

Span of Control by Job Function, Grade

Turnover Compa Ratio - Current Quarter

Average Compa Ratio - Current Quarter

Top Performer Compa Ratio - Current Quarter

Leavers Compa Ratio - Current Quarter

Compa Ratio By Grade Name

Compa-Ratio, Performance Rating By Employee

Compa Ration by Function, Manager

Compa Ratio by Location

Compa Ratio By Length of Service

Total Managers

Disability Workers

Foreigners

Nationalities

Average Workers Age

Average Year of Service

Workers By Gender

Managers by Gender

Nationalities & Ethnicities

Temporary & Part Time Workers

Worker Details

Headcount By Legal Employer

Span of Control By Legal Employer

Headcount by Age Band

Headcount by Tenure Band

Hires

Terminations

Turnover Percentage

Hires and Terminations By Gender and Legal Employer

Hire Details

Hire By Age Band

Termination Details

Terminations By Age Band

Top Talents - Current Quarter

Worker without Rating - Current Quarter

Retention by Talent %

Top Talent

Retention % by Top Talent, High Potential, High Performer

Average Tenure Years

Contingent Workers

Top Performers

Worker Count by Job Family, Business Unit Name

Worker Count By Location

Compa-ratio By Job Family

Worker Count by Worker Type

Worker Count By Performance

Turnover By Month

Turnover By Business Unit, Gender

New Hire Turnover By Business Unit, Gender

Turnover by Age group, Gender

Turnover By Employee Ethnicity

Voluntary Turnover by Region

Turnover Details

Distribution - Current Quarter

Turnover Percentage - Current Quarter

Promotions - Current Quarter

Hires - Current Quarter

Distribution Current by Month

Turnover Percentage by Month

Promotions by Month

Hires by Month

Leavers

New Hire Turnover

Hires. Leavers by Job Family

Hiring Details by Manager

Hires by Location

Percentage of Worker created atleast 1 goal

How well balanced are goal types

No of development by no of performance goals

goals created

% of workers with Goals in progress

Goals not started

% of Workers completed goals

No of workers with Goal overdue

% of workers

Internal Mobility in your Team

Hires

Terminations

Workforce

Demographics

Hires and Leavers

FDI has almost 300 pre-built KPI's/Visualizations, which subject area's are not part of Data Validation feature, how do I validate their data ? Even with FDI metrics lineage all are not possible to calculate through OTBI as most of the referenced column/fields are with different names in OTBI. Additionally OTBI has its own filter in the backend subject areas.

Answers

  • RVohra
    RVohra Rank 6 - Analytics & AI Lead

    It is definitely interesting question; I would also like to understand it.