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

Job application missing the unconfirmed applications

Needs Votes
26
Views
4
Comments
Ivancho
Ivancho Rank 2 - Community Beginner
edited Jul 7, 2025 6:46PM in Oracle Fusion Data Intelligence Idea Lab

In HCM, we can see the unconfirmed applications and also in the FDI dimension, but that is not present in the fact table “DW_TA_JOB_APP_EVENT_F_SEC”, hence, we are not able to display it in the dashboard KPIs.

Tagged:
2
Up
2 votes

Needs Votes · Last Updated

Comments

  • Raghavendra Raghunath-Oracle
    Raghavendra Raghunath-Oracle Mod

    Hi @Ivancho what is your exact requirement around the unconfirmed applications? If you want to show the count and the application details, you can do it using the dimension itself. Please provide further details.

    Thanks

    Raghu

  • Ivancho
    Ivancho Rank 2 - Community Beginner

    Hi @Raghavendra Raghunath-Oracle,

    It is good to know this is progressing. Thank you for your assistance!

    - Requirement needs both Active and Unconfirmed applications visible in FDI, consistent with what is available in HCM (see below screenshot).

    image.png

    New - New Applicant // Active Applications // Hires Out // Unconfirmend Applications // Referred Prospects

    - Issue observed: Applying the attribute/dimension filter APPLICATION_CONFIRMED_FLAG = 'N' in FDI returns no data for Unconfirmed applications.

    - Findings: Debugging the query we identified that the fact table DW_TA_JOB_APP_EVENT_F_SEC currently lacks events where APPLICATION_CONFIRMED_FLAG = 'N'. Consequently, those records do not display in FDI.

    - Expectation: CEAL guidance states that DW_TA_JOB_APP_EVENT_F_SEC should, by default, contain all applications, without relying on additional dimension data.

    - Request: Populate DW_TA_JOB_APP_EVENT_F_SEC with the missing APPLICATION_CONFIRMED_FLAG = 'N' events so they are available in FDI.

    Thx

    Ivancho

  • Raghavendra Raghunath-Oracle
    Raghavendra Raghunath-Oracle Mod

    Hi @Ivancho You can report on unconfirmed job applications using a custom calculation. For example: A calculation column with the below formula

    COUNT(DISTINCT "HCM - Talent Acquisition"."Job Application - Basic Information"."Job Application Identifier")

    have a viz level filter as below

    "HCM - Talent Acquisition"."Job Application - Basic Information"."Confirmed Flag" <> 'Y'

    Raghu

  • Raghavendra Raghunath-Oracle
    Raghavendra Raghunath-Oracle Mod

    Hi @Ivancho You can report on unconfirmed job applications using a custom calculation. For example: A calculation column with the below formula

    COUNT(DISTINCT "HCM - Talent Acquisition"."Job Application - Basic Information"."Job Application Identifier")

    have a viz level filter as below

    "HCM - Talent Acquisition"."Job Application - Basic Information"."Confirmed Flag" <> 'Y'

    Raghu