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'
Hi All, In our organization, data security is highly customized and complex. A single user can have multiple custom data roles assigned based on different security contexts, such as Line Manager, Regional Manager, Country, Area of Responsibility (AOR), Organization, and other business-specific access rules. One of the…
a { text-decoration: none; color: #464feb; } tr th, tr td { border: 1px solid #e6e6e6; } tr th { background-color: #f5f5f5; } Hi All, In our organization, data security is highly customized and complex. A single user can have multiple custom data roles assigned based on different security contexts, such as Line Manager,…
Idea / Enhancement Request Oracle Analytics Cloud (OAC) has introduced the capability to provide public access to analytics content using the BI Public Role, allowing reports and dashboards to be shared with users without requiring authentication. I would like to propose extending similar functionality to Oracle Fusion…
hi All, The existing FDI pre-built artifacts/Common Subject Areas give us useful information about data reload and warehouse refresh activities. However, I see a gap when troubleshooting Data Augmentation execution at row level. For example, we have a BI Publisher report returning approximately 1M rows, but the…
In Fusion Data Intelligence (FDI) release 26.R3.P4, Reporting Configuration provides options to hide Human Capital Management (HCM) and Enterprise Resource Planning (ERP) content. However, an equivalent option is not available for Fusion Supply Chain Management (SCM) content. SCM content remains visible in the catalog…
