Oracle Fusion Data Intelligence Idea Lab

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

Planned
213
Views
22
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:

5
5 votes

Planned · Last Updated

«1

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 ✭✭✭

    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 ✭✭✭

    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 ✭✭✭

    @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 ✭✭✭

    @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 ✭✭✭

    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

  • Mike Tytler
    Mike Tytler ✭✭✭

    @Raghavendra Raghunath-Oracle yes - we would like to see the Number of Openings Left to Fill from the OTBI subject area you referenced included in the Fusion Analytics Warehouse HCM - Talent Acquisition subject area.

  • @Mike Tytler thanks so much for the confirmation. Will get this added.

    Raghu

  • Gina DiVenti
    Gina DiVenti ✭✭✭
    edited June 25

    @Raghavendra Raghunath-Oracle Thank you so much for getting this added. Do we have an anticipated timeframe for when it will be added?

  • @Gina DiVenti

    Right now, 24R3 is going on and is locked. Best case would be 24R4. I can keep you posted.

  • Gina DiVenti
    Gina DiVenti ✭✭✭

    Thank you!

  • 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 check if this works for you? Based on your feedback i plan to retain/modify this

    Thanks

    Raghu

  • Mike Tytler
    Mike Tytler ✭✭✭

    @Raghavendra Raghunath-Oracle I just reviewed the report you provided on July 3rd. Unfortunately its the same problem/feedback.

    FDI is lacking a fact/metric equivalent to OTBI.

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

    The report that you provided in FDI leverages "Openings Filled" which equates to applicants in the "HR Processed" Phase/State based on documentation. HR Processed state only occurs when the person is converted to an employee so could be months after offer accepted.

    Formula/what we need in FDI:

    Total Openings - (applicants in Offer accepted Phase/state OR any HR phase) = Openings Left to Fill

  • 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 is lacking a fact/metric equivalent to OTBI - I wanted to run by you before i seed this in the subject area, for validation

    Raghu

  • Mike Tytler
    Mike Tytler ✭✭✭

    @Raghavendra Raghunath-Oracle

    My preference would be to have the OTBI "Number of Openings Left to Fill" and this new FAW fact be identical.

    I am not sure of all of the logic in the OTBI fact. Is there someone on the Fusion HCM/Recruiting side that you can consult with?

    To help, I did some testing in our environments to figure out what OTBI is doing:

    1. Rejected candidates are excluded
    2. Withdrawn candidates are excluded
    3. Offer Accepted (phase/state) is included
    4. HR any state is included
    5. unlimited opening requisitions are excluded.
    6. any custom phases a customer makes between Offer and HR are excluded. I can potentially see customers not liking this but I still strongly think that the two metrics need to be in alignment (OTBI and FAW). If customers customize their CSP (phase/state) then may need to create custom formula like your example above.

    If I think of anything else I can provide another update, but again if we can get someone from the Oracle recruiting side provide you with the OTBI "formula" that would be the best approach.

    I also tried creating a sample visualization with the formula from your last update. We would want to see openings to fill over time so I did a simple line graph and filtered on just one requisition (#1695) - screenshot below. This requisition has 4 total openings and 2 candidates that are currently in the HR phase.

    1. Looking at the results - 2023 Q2 shows 2 openings to fill. We had one candidate move to HR phase during this quarter - not sure why it is showing 2. We would expect a value of 3.
    2. 2023 Q3 - We had one candidate (different than #1) move to the HR phase in this quarter. Report shows 3 openings - so it is ignoring candidate from #1 since it is outside of this quarter. We would expect a value of 2.
    3. 2023 Q4 and beyond is the same problem. We would expect openings to fill to be 2, but report has 4 because it is not accounting for candidates from prior quarters.

    I wanted to call out this use case so you can see how we would want to use this metric. Other customers might have additional requirements too.

  • Gina DiVenti
    Gina DiVenti ✭✭✭

    I would agree with everything Mike said. His parameters for what OTBI is using match what I have seen, and I agree OTBI and FDI/FAW should match. Also point in time reporting on this field would be amazing!