Oracle Fusion Data Intelligence Idea Lab

Home› Oracle Analytics› Oracle Analytics Idea Labs› Oracle Fusion Data Intelligence Idea Lab

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Add measure Number Openings Left to Fill to the FAW HCM Talent Acquisition Job Requisition fact

Planned
309
Views
30
Comments
13»

Comments

  • Raghavendra Raghunath-Oracle
    Raghavendra Raghunath-Oracle Mod

    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.

    However, the requirement posted above by @Mike Tytler is to get the trend of 'hired count' and 'openings to be filled' by time period and this is not in OTBI today

    Raghu

    openings to fill.png
  • Rohith Banda-Oracle
    Rohith Banda-Oracle Rank 1 - Community Starter
  • Gina DiVenti
    Gina DiVenti Rank 5 - Community Champion
    edited Oct 31, 2024 5:41PM

    @Raghavendra Raghunath-Oracle do we have an update on this topic? Do we have a timeframe for when Openings Left to Fill will be added to FDI?

  • Krish1323
    Krish1323 Rank 1 - Community Starter

    @Raghavendra Raghunath-Oracle

    Do we have an update on this "Openings Left to Fill" will be added to FDI?

  • Raghavendra Raghunath-Oracle
    Raghavendra Raghunath-Oracle Mod

    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

  • Gina DiVenti
    Gina DiVenti Rank 5 - Community Champion

    Thank you for the update. I sent you a message.

  • Raghavendra Raghunath-Oracle
    Raghavendra Raghunath-Oracle Mod

    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

  • Gina DiVenti
    Gina DiVenti Rank 5 - Community Champion

    In FDI the formula for hires is below, which matches what we consider a hire (aka the opening is filled).

    image.png
  • Mike Tytler
    Mike Tytler Rank 3 - Community Apprentice

    @Raghavendra Raghunath-Oracle - I am wondering if this is an opportunity to make FAW more flexible than Fusion OTBI reporting.

    My initial preference was to keep the new FAW fact be the same logic as the existing OTBI "Number of Openings Left to Fill" for consistency and to avoid user confusion (why are numbers different in OTBI vs FAW). ie: any job application that is in the state Offer Accepted or any state in HR phase other than withdrawn and rejected would be counted and deducted from the total openings.

    Could another fact be added that would equate to Number of job applications in the HR phase (ex: the logic Gina provided).

    That way customers can pick whatever one works best for them?

    One based on offer accepted —>

    OR

    One based on "Filled"/HR phase

  • Raghavendra Raghunath-Oracle
    Raghavendra Raghunath-Oracle Mod

    Hi @Mike Tytler @Gina DiVenti

    Thanks for the feedback. I plan to have 2 measures for Openings Filled

    1. Count(Job Application ID) Where Phase = HR and State Not IN (Rejected, Withdrawn)  - same logic as Gina mentioned above
    2. Count(Job Application ID) Where Phase = HR and State = Processed

    Openings to be Filled also will have 2 versions based on the above

    p.s. - Please note that Openings Filled based on Offer Phase is not in place

    Raghu