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.
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
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).
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
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'
Organisation Name UK Public Sector Summary Add a prebuilt Internal Help Desk analytics subject area, with supporting data pipelines and semantic model, to enable reporting on Internal Service Requests alongside the existing HR Help Desk analytics capability. Current gap In FAIDP/FDI , HR Help Desk analytics is available,…
I am working with a number of customers who only have ERP from Oracle and a skinny HR record to support this in HCM for things like expenses. Many of these customers want to be able to link a level of HR data to supplement what they have in ERP but this takes a lot of custom effort. This idea would see the introduction of…
1. Business Need / Problem Statement: Currently, configuring an Oracle Analytics Publisher (BI Publisher) connection within the Fusion Data Intelligence (FDI) Console to extract and load data into FDI only allows Basic Authentication (username and password credentials). With Oracle deprecating basic username/password…
Generate Audit report should have all the Business Object Type in the schedule process
We are evaluating the use of Oracle Guided Learning (OGL) within Fusion Data Intelligence (FDI). Today, Oracle Guided Learning is available within Oracle Fusion Applications and EPM as an integrated experience where users can access guidance directly within the application. Within FDI, the currently supported approach…
