@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

thanks, Manju @Manjunath Subramanian-Oracle @Lauriane Massin Whitaker ,fyi use this attached dv, you can modify the year, LE in the report Raghu

Hi @Mike Tytler @Gina DiVenti currently what we have in OTBI is a balance metric. i.e. for a requisition, it provides what is the hired count and openings to be filled. You cannot get a trend of hired count and openings to be filled by various time periods, like quarter/month/year etc. refer the attached screenshot.…

Hi @Mike Tytler please re-check the formula that I have for the column 'Left to Fill' I have tried to mimic the same logic as in OTBI Going by your formula above, is it ok to consider the Job applications in HR phase which are in withdrawn or rejected states also? In my formula, i have excluded them on your comment - FDI…

Dear @Gina DiVenti , @Mike Tytler , @Lea B I am in the process of seeding this openings left to fill measure at the grain of the requisition. This will be a balance metric i.e. as of current, how many openings are yet to be filled for a requisition. I was trying to mimic the same logic that we have in OTBI(in FDI) Can you…

an another version of this can be like below "HCM - Workforce Core"."Time"."Date" BETWEEN TIMESTAMPADD(SQL_TSI_MONTH,-11,CURRENT_DATE) AND CURRENT_DATE