nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Add DW_WRKFRC_ASG_F.PAY_SYSTEM_STATUS to the HCM subject areas

Victor H

The ADW table DW_WRKFRC_ASG_F already has this column (PAY_SYSTEM_STATUS) but it cannot be added to the semantic model.

The "Add column" semantic model action does not include this column, We opened a SR and found out that it is not part of the RPD physical layer and this requires an enhancement request/idea lab.

This column is important to identify if specific assignments are processed in payroll runs

Find more posts tagged with

Under Review

Oracle Fusion Analytics

HCM

FDI Back End

FDI

Status: Under Review

Comments

Victor H

This looks like a low effort and high reward enhancement; The column is already there on the DW table and it just needs to be pushed to the physical layer.

For reference:

SR 3-36679457111 : Cannot add DW_WRKFRC_ASG_F.PAY_SYSTEM_STATUS column in semantic mode

Nupur Joshi-Oracle

Hi Victor , Would you also mind sharing the functional use case/analytical need for which you need this column exposed in the subject area ? Also , in which specific subject area do you need to be exposed ?

Regards,

Nupur

User_V7621

We need to have a employee detail report where we need to show employee payroll status. Please add column in

HCM - Workforce Core subject area