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'
Currently, scheduling functionality is available primarily for workbooks and dashboards developed using the Classic reporting method. Extending similar scheduling capabilities to workbooks and dashboards developed using Data Visualization (DV) would significantly improve the usability and adoption of these reporting…
Fusion App data is frequently refreshed from our Fusion Production environment. As a result, in order to sync the data in our FDI non production environments a full reload is needed. Due to volumes of our Fusion Production, the task to perform reload of the data will take 1-2weeks to complete. Depending on the frequency,…
Hi All, I see several upcoming changes in Fusion HCM Core HR, including new employee attributes such as Preferred First Name and Preferred Last Name. Since we have multiple Oracle FDI workbooks currently live with business users, we need to assess whether these HCM changes have any downstream impact on our existing…
Requesting a toggle to suppress zeroes and nulls in tables and pivots in similar fashion to that of SmartView functionality. Currently there is native suppression, but this functionality rarely excludes zeroes appropriately resulting in many rows of non-meaningful data. Filtering zeroes out is theoretically an option, but…
Idea Enhance FDI Custom Data Security to allow permitted data values to be configured directly within a Data Role, rather than requiring all values to be granted separately through user-level Security Assignments. Use Case Our organisation uses row-level data security based on Chart of Accounts segment values that align to…
