Hi @Gina DiVenti This release (25R2, May-2025) we added the Position Hierarchy. Have the Department Hierarchy in the roadmap and get it added. Raghu

Hi @JT_DC_2023 your requirement can be met using the event metric. The event metric does provide you the trends, and the latest statuses. I am unable to attach the dv here, will message you privately Raghu

Hi @Mike Tytler @Gina DiVenti Thanks for the feedback. I plan to have 2 measures for Openings Filled Count(Job Application ID) Where Phase = HR and State Not IN (Rejected, Withdrawn) - same logic as Gina mentioned above Count(Job Application ID) Where Phase = HR and State = Processed Openings to be Filled also will have 2…

Hi @JT_DC_2023 can you please outline your reporting requirement, we can take it from there to see if it is possible at all or not. Raghu

Hello All, can you share what is criteria for you to call an opening as filled? In ORC, any job application that is in the state Offer Accepted or any state in HR phase other than withdrawn and rejected is classified as 'filled' Is there any other suggestion from any of you? Raghu

Hi @Gina DiVenti @User_C8FCF This has been in the roadmap for a while and is being considered for enhancement in 25R3 which is approximately Aug-25. Would you want to join me for a meeting to help me understand if you need any additional metrics around this? If yes, please message me directly. Raghu

Hi All, thanks for engaging on this topic. I agree with Sushanta's response above. The average depends on the grain of the query. If year is the lowest grain then the headcount as of first day and last day of the year is considered for the average If month is the lowest grain then the headcount as of first day and last day…

Hi @JT_DC_2023 have you tried using the metric Total Job Applications (On Event) under the folder Facts - Job Application Events? This provides both active and inactive Raghu SELECT "HCM - Talent Acquisition"."Job Application - Basic Information"."Active" s_1,…

Hi @Lauriane Massin Whitaker can you please re-share your reporting requirement. I can check and respond next week. Raghu

Hi Liwen @Liwen Chiu try this select username from per_users where person_id = NVL(HRC_SESSION_UTIL.GET_USER_PERSONID, - 1) Raghu

@Liwen Chiu @MandeepGupta @Bhaskar Konar FYI can you try this select username from per_users where user_guid = fnd_global.user_guid Raghu

Hi @Toni Olivier, is this column that you are referring to available in the HCM application? The important date attributes related to Job requisition are as below(in FDI subject area) Raghu

Hi Sam, Currently, The Seniority Data for the combination of worker and the rule name is as of the latest date on which the process was run to compute the seniority. For example: A worker's seniority for a rule is 3 Years hence is categorised under 3-4 Years band Your requirement is, hypothetically if the rule was run last…

Hi @Sam Reinhart can you please provide an example as to how you plan to use Time dimension with the seniority data of the workers? This subject area provides you the latest seniority of the worker for each of the rules that have been setup. A sample tabular illustration of how you plan to use this data with Time dimension…

Hi @Edwin_Martinez you can use this formula FILTER("HCM - Workforce Core"."Facts - Workforce Headcount"."Manager Count" USING "HCM - Workforce Core"."Manager Information"."Manager Person Number" IS NOT NULL AND "HCM - Workforce Core"."Assignment Information"."Assignment Type"='Employee') Raghu

@SameerJain Please let me know if you are working with any of your customers to enable the HR Help Desk functional area in FDI. I would like to get a feedback from you/your customers on this. If this helps them in their analytical requirements and if there are any additional features required. Please message me(if…

Hi @SameerJain great to hear from you, been a while since we met. HR Help Desk dashboard is not yet productized and seeded in the catalog. Right now, i am sharing this with whoever is interested in turning on this feature. Will add it as an OOTB offering in CY 2025. Raghu

Hi @JobDeLuna In OTBI or DV you can use the following function if the columns have timestamp on them, for example: TIMESTAMPDIFF(SQL_TSI_HOUR,"Worker"."Assignment Start Date","Worker"."Assignment End Date") Raghu

Hi @Bart S in your OTBI query, can you add the following columns along with the 3 that you have mentioned above Assignment Event Details.Assignment Number Assignment Event Details.Assignment Type HR Action.Action Type Code You may notice that for 3 of your workers there are 2 assignments, Pending Worker and Employee Can…

Hi @Gloria Brewster This ask above on joining Person Real Time and Assignment Event Real Time has been answered. What are you waiting on? Is there any use case that you have to find a solution? Raghu