nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle AI and Analytics

Child Item

Headcount Turnover measure in FDI, seeking clarification

Rich R.

We are trying to clarify the 2 data sets that go into the oracle-delivered "Headcount Turnover" measure. This measure is found in FDI, in "HCM - Workforce Core"."Facts - Workforce Headcount" subject area
We have our own internal calculation, which is a few percentage points different than this measure, which is why we are looking to clarify any filters used on the Headcount or Terminations data that goes into the delivered measure. The oracle documentation shows this is the calculation used in the measure: 100*(Termination headcount/Average Headcount)

I have tried to answer the below questions, but am not confident in what has come out of trying to back into the details from the measure. Any help on these would be appreciated:

For either the Headcount or Terminations data sets that go into the "Headcount Turnover" calculation:
Is there a filter for Regular/Temp values of the associates?
Is there a filter on User Person Type or System Person Type values of the associates?
Is there a filter on Assignment Type values of the associates?
Is there a filter on Assignment Status values of the associates?

Thank you 😉

Find more posts tagged with

HCM

FDI

Accepted answers

Raghavendra Raghunath-Oracle

Hi @Rich R. Please refer to the Metric Compute logic spreadsheet -

Is there a filter for Regular/Temp values of the associates? - No
Is there a filter on User Person Type or System Person Type values of the associates? - No
Is there a filter on Assignment Type values of the associates? - No
Is there a filter on Assignment Status values of the associates? - Yes (Active, Suspended)

Thanks

Raghu

All comments

Raghavendra Raghunath-Oracle

Hi Rich, fyi

Termination Headcount takes into account the headcount of all assignments that are in active, suspended assignment status types that went through the termination event (EMPL_TERMINATE).

Thanks

Raghu

Rich R.

Thanks, @Raghavendra Raghunath-Oracle

Hoping to get a more complete answer to the questions I have in this post.

Raghavendra Raghunath-Oracle

Hi @Rich R. Please refer to the Metric Compute logic spreadsheet -

Thanks

Raghu

Rich R.

Thank you for the follow up, @Raghavendra Raghunath-Oracle

All those "No's" should explain our variance! 😃

I do have a copy of the Metrics spreadsheet, but didn't see the detailed answers that I was looking for. I greatly appreciate the response.

Upcoming Event

Analytics - Oracle Fusion Data Intelligence (FDI) Product Roadmap Update
Description: The Oracle Fusion Data Intelligence (FDI) Product Roadmap Update provides an overview of the latest developments and future plans for FDI. Oracle Product Management experts will share upcoming capabilities, key enhancements, and product direction, helping attendees understand what is changing and how these…

Top Leaders

Indranil Basak-Oracle 15