Oracle Fusion Data Intelligence Idea Lab

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
232
Views
23
Comments

Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Penske Truck Leasing Co LP


Description (Required): FAW currently does not offer the measure of 'Openings Left to Fill' under the HCM Talent Acquisition subject area. the measure is offered in OTBI.


Use Case and Business Need (Required): reporting openings left to fill across multiple dashboards and standardization of measurement. existing measure 'total openings' does not update as positions on the requisition are filled and offers are move to HR.


Enhancement Request / Service Request:

6
6 votes

Planned · Last Updated

«13

Comments

  • Hi @Lea B yes, we will add this measure, any other key metrics that you want to add? you can suggest something that is not available in OTBI also

    Raghu

  • Gina DiVenti
    Gina DiVenti Rank 3 - Community Apprentice

    Did this field get added and if so can you share the field name?

  • Hi @Gina DiVenti, this feature is currently in development so it has not been released yet.

  • Mike Tytler
    Mike Tytler Rank 3 - Community Apprentice

    We are in the process of implementing FAW and just noticed that Openings left to Fill and Openings Filled are not available in the HCM - Talent Acquisition subject area. It's extremely disappointing as the product documentation https://docs.oracle.com/en/cloud/saas/analytics/24r2/faihc/24R2_HCM_Metric_Calculation_Logic.xlsx

    has consistently had both of these metrics listed.

    I opened SR 3-37085076771 : FDI - Openings to be Filled Metric and was told it is a documentation issue.

    Glad to see other customers started this idea and Oracle is working on adding this metric.

    @Jamie Anderson-Oracle - In addition to the Openings left to fill, can Openings Filled also be added?

  • Hi @Mike Tytler yes, apologies on the confusion. Added into the documentation before seeding it in the subject area. I shall get these metrics added, also update the documentation by next release.

    Raghu

  • @Lea B @Gina DiVenti @Mike Tytler @Jamie Anderson-Oracle

    have you tried using the existing hires column? and use that to compute the openings to be filled metric? I hereby share a sample dv, please import and check if it works for you.

    Raghu

  • Mike Tytler
    Mike Tytler Rank 3 - Community Apprentice

    @Raghavendra Raghunath-Oracle

    Thanks for the suggestion, this is definitely something we can test out.

    A couple of thoughts:

    1. I would really like to see this as a standard metric in the subject area at some point in time. Business users will want to drag and drop and not have to worry about a calculation to create their visualization.
    2. OTBI has an Openings to be Filled metric. That includes applicants in Offer Accepted phase/state or applicant in the HR Phase. So this FAW computation would be different in that it is only looking at applicants in the HR phase. My preference would be consistency between Fusion OTBI and FAW facts/metrics.

  • Mike Tytler
    Mike Tytler Rank 3 - Community Apprentice

    @Raghavendra Raghunath-Oracle

    Now that I look at this closer - to elaborate on my item#2:

    OTBI - Openings Left to Fill: includes applicants in Offer Accepted phase/state or applicant in the HR Phase (any state).

    FAW - "Hires" are applicants in HR/Processed Phase/State based on documentation. Processed state only occurs when the person is converted to an employee which can take time to get through all of our compliance requirements PLUS the candidate may not be ready to start immediately and may need to provide notice to prior employer.

    The manual calculation you suggested would be very different than we would expect based on the Fusion definition.

    I appreciate the create solution, but it won't work for us as is - definitely open to any other suggestions you have.

  • Gina DiVenti
    Gina DiVenti Rank 3 - Community Apprentice

    Mike said it perfectly. We have "hires" that start many months out (so they are not in the processed state yet). It is currently very difficult to get a count of openings left to fill in FDI without this metric that exists in OTBI.

  • @Mike Tytler @Gina DiVenti

    Just to confirm, your expectation is to have this metric(highlighted in the attached screenshot below) available in OTBI - Recruiting Real Time to be added to HCM - Talent Acquisition subject area

    Raghu