Does anyone have a dashboard for time in each stage of the recruitment process including: Apply to phone screen, phone screen to interview, interview to offer, and offer to start?
Have you explored the phase and state completion duration metrics? These are really great for tracking how long the candidates are in each phase and state.
We have also built custom calculations that measure the time difference between two Oracle dates (we had to explore different aggregation methods to make these accurate, so be careful to validate closely):
Avg (TIMESTAMPDIFF(SQL_TSI_DAY,"HCM - Talent Acquisition"."Job Application - Dates"."Job Application Submitted Date","HCM - Talent Acquisition"."Job Offer - Basic Information"."Accepted Date"))
If there isn't a date tracked in the system but a phase or state is changed, we have also had success using the date the phase or state is activated:
AVG( CASE WHEN "HCM - Talent Acquisition"."Recruiting History Event Type"."Event Type Name" = 'State Activated' AND "HCM - Talent Acquisition"."Recruiting State"."State Name" = 'Selected for Offer' THEN TIMESTAMPDIFF( SQL_TSI_DAY, "HCM - Talent Acquisition"."Job Application - Dates"."Job Application Submitted Date", "HCM - Talent Acquisition"."Time"."Date" ) ELSE NULL END )
Hi @Nathan Yeager,
Welcome to the Oracle Analytics Community!
Please take a look into the following post which might not be exactly same as your requirement but it will give you some content which can be extended.
HCM FDI Release 25R3 (Aug-2025) - Recruiting Analytics — Oracle
Additionally, you can take a look into the following area for shared contents.
Oracle Analytics Sharing Center — Oracle
Hope this help.
Thank you.
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…
How to show amount columns with currency symbol and format in AI Agent response. Provided sample in supplement instruction but it is not displaying based on format
After the recent Oracle FDI/OAC release updates, both our PROD and DEV environments no longer display the Data | Visualize | Present tabs at the top of the workbook.Previously, I used the Present tab to: Hide or show specific canvases/visualizations. Hide filters used in the workbook. With the new workbook interface, I…
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…
My data: My Calculation - above in the last column you can see it works great: So why the heck my table goes blank for every value in Month End Date filter?
Dear Experts, We are trying to add security steps to our new implementation but the option that is mentioned in oracle documentation and also seen on other existing implementations is not available in our instance. The Navigation is FDI Console> Semantic Model Extensions> Security Configurations> Data Security Step.…
