Hi @User_T4SS6 Can you please confirm which functional area are you referring here? Is it about Project management or HCM? Raghu

Hi @Alex van Gulijk you can create as many data actions as you require, fyi Raghu

@MandeepGupta Hey Mandeep, It was a conscious decision to bring in many of these PII and Sensitive information into the warehouse. A few basic ones like gender, ethnicity, disability flag etc we did add but not others like National ID, Email ID, Phone No. etc Data Augmentation using BI VO's is our recommendation for such…

Hi @Vijay Sridharan This is taking longer than we expected due to various priorities. This is definitely in our roadmap. Can I request you and others on this thread to share your respective use cases. Cancel Work relationship can happen at any pint in time, not necessarily the 'no show' workers after hiring. For ex: There…

@Bhaskar Konar Hi Bhaskar, I acknowledge your request. Thanks Raghu

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