Oracle Fusion Data Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Fusion Data Intelligence› Oracle Fusion Data Intelligence

Categories

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

Termination date appearing in following Enterprise Period – FDI

Accepted answer
51
Views
5
Comments
Scott_Turner_
Scott_Turner_ Rank 5 - Community Champion
edited Aug 13, 2024 7:27PM in Oracle Fusion Data Intelligence

When working on Turnover reports/visuals in Fusion Data Intelligence Terminations which fall on the last day of the month fall into the following Enterprise Period.

I am aware this is how Oracle calculates terminations however, I am curious to understand how other companies are calculating their turnover data in FDI?

Have you moved to calculating as per FDI or do you have a work around that you have implemented?

Tagged:

Best Answers

  • Scott_Turner_
    Scott_Turner_ Rank 5 - Community Champion
    Answer ✓

    Hi @Rajesh L-Oracle It is more the use of Enterprise Period and when the termination date falls on the last day of the month it count the termination in the following period. (see image below: Noting that the two terminations which occur on 29/02/2024 are being counted in Mar-2024 Enterprise Period.) When you utilise Enterprise Period to calculate turnover it skews the calculations as to how they are normally calculated in Australia.

    Screenshot 2024-04-26 080159.png
  • Richard Kemp-Eyre
    Richard Kemp-Eyre Rank 5 - Community Champion
    Answer ✓

    Hi Scott,
    We've experienced exactly the same issue when trying to use the facts in the Workforce Trend Real Time Subject Area.

    The facts are based around the Effective Start Date of the employee's assignment for the entry after their termination - see screenshot below as an example. This example assignment is counted as an April Leaver.

    The documentation for this Subject area states:

    Time Reporting

    This subject area can be used to report on the headcount trend over a period which is historical data reporting.

    Time dimension is linked to Trend month is determined by comparing Calendar Month falls between assignment_Effective_Start_Date and Assignment_Effective_End_Date.

    See https://docs.oracle.com/en/cloud/saas/human-resources/23d/faohb/Workforce-Management--Workforce-Trend-Real-Time-SA-10.html#Workforce_Management__Workforce_Trend_Real_Time_SA_10_d1e17396

    image.png

    We've tried playing with timestampadd on the various assignment_Effective_Start_Date fields but gave up.

Answers

  • Rajesh L-Oracle
    Rajesh L-Oracle Mod

    Hi @Scott_Turner can you share details which specific metric you are using for validation and if you are using any metrics in OTBI for data comparison if there is any data mismatch in FDI we can debug via Support SR

    @Nupur Joshi-Oracle can you please share if there are any plans to make any update in headcount/turnover calculation for last day of month in FDI

  • Tessa22
    Tessa22 Rank 2 - Community Beginner

    Has anyone had any luck/further traction on this? I'm trying to create a new Worker Turnover calculation using Termination Count(Termination Date), but not having much luck:

    image.png
  • Tessa22
    Tessa22 Rank 2 - Community Beginner

    This workaround calculation may work for you @Richard Kemp-Eyre and @Scott_Turner_:

    Worker Turnover (Termination Date)
    Purpose: Calculates worker Turnover by Termination Date, rather than Assignment Start Date
    Calculation:
    100 * (
    "HCM - Workforce Core"."Facts - Workforce Attrition(By Termination Date)"."Termination Count(Termination Date)"
    /
    "HCM - Workforce Core"."Facts - Workforce Person Count"."Average Worker Count"
    )