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'
I have a use case for FDI connectors whereby I need to use the EPM Integrator to include planning data in my environment but I have 2 separate EPM environments, one for ERP and one for HCM. Once you create a connection using a connection type, the option to create a new one disappears. This creates an issue where customers…
In the out of the box workbooks, many have default filters for items such as Ledger and Business Unit. Most of these default to the first value alphabetically. This can be incredibly frustrating for users who, when logging in for the first time often get no results or results they are not expecting when they first log in.…
With continuous capabilities being brought into the modern Data Visualisation (DV) experience in OAC and FDI, a native equivalent to the View Selector from Classic Analysis / OBIEE is needed. In Classic reporting, the View Selector allowed users to dynamically swap between different chart types, tables, or analytical views…
OAC saved states are lost when the workbook is moved / migrated to another environment. This feature is intended mostly for personal user preferences but it is also useful for providing preset selecitons for users. If we want to make these presets available for all users , the only way is opening the workbook in the new…
Many organizations need to produce a single employee-level report that combines information from multiple Oracle Fusion Data Intelligence HCM subject areas, including: Workforce Core Goals and Career Development Performance Management Talent Profile Talent Profile Trends A common requirement is to extract, in a single…
