Hi @User_4YZZC you are looking for a query in FDI or OTBI? task archive date/purge date are not available in the subject areas in both the products. Raghu

Hi @KMelesio we will take this as a roadmap request. Thanks Raghu

Hi @Shashank1991 Can you assign both these duty roles to your data role, regenerate the data role and test again. * ORA_FBI_ABSENCE_MANAGEMENT_TRANSACTION_ANALYSIS_DUTY_HCM * FBI_ABSENCE_MANAGEMENT_TRANSACTION_ANALYSIS_DUTY Raghu

Hi @Ayoub Afrass_1 Your requirement needs the support of Core subject area as well, Check this attached dv Raghu

Hi Alex, can you import and test this workbook. I have the two data actions built in it. Raghu

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