Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Termination date appearing in following Enterprise Period – FDI

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?
Best Answers
-
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.
0 -
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
We've tried playing with timestampadd on the various assignment_Effective_Start_Date fields but gave up.
1
Answers
-
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
1