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

Hi @User_LW96B Please use an expression filter criteria like below "HCM - Workforce Rewards - Salary Basis"."Worker Salary Basis Details"."Salary Change Start Date" = (MAX("HCM - Workforce Rewards - Salary Basis"."Worker Salary Basis Details"."Salary Change Start Date" by "HCM - Workforce Rewards - Salary Basis"."Basic…

Hi @Lauriane Massin Whitaker did you try adding both the New Hire Headcount and Assignment Count to the report along with the worker category and duration? Did that work? Raghu

Hi @Ruvina Khan As you know, there can be many custom sections that you can create using the seeded content types. We cannot seed all of them, obviously. Hence, we added the 'All Profile Content' folder which can be used to report on all sections across skills & qualifications, and Talent Ratings including custom defined…

Hi @Ruvina Khan This is available for reporting in a new subject area named HCM - Talent Profile Trends. This is part of 24R3 . Should be available end of this month. You can use the All Profile Content folder in this subject area to report on custom sections. Raghu

Hi @Ruvina Khan Is 'Organization Review Data' a section in Cloud HCM Talent Profile? just like other sections, for example: degrees, license and certifications etc? Raghu