Oracle Communities

Oracle Analytics and AI

Child Item

HCM - Workforce Rewards: Payroll costing doesn't have Pay week ending date granularity in GIA

We do not see a "Week Ending" Date Earned field/Granularity in the GIA OOTB HCM Payroll Balances or Payroll Costing subject areas.

Some of the requests Payroll receives need to be broken down by week date and as it stands right now that is not available, only pay period end date. The date earned we are looking for is the actual week ending date, which is different than the pay period begin/end dates or check date.

Find more posts tagged with

Under Review

Fusion HCM Analytics

Fusion Data Intelligence FDI

Status: Under Review

Comments

Nupur Joshi-Oracle

Do you have weekly Payroll defined ?Kindly share more details of your exact use case. We have all the date attributes supported in FDI as available on Payroll Setup / OTBI subject areas too. So is there any attribute that is missing ? The ask is not very clear from the problem statement provided.

Sheila Romane

We do not have a weekly Payroll defined. We have bi-weekly and monthly.

Our use case is: The Payroll Team does not see a "Week Ending" Date Earned field in the GIA Payroll Balances or Payroll Costing subject areas.

Some of the requests Payroll receives need to be broken down by week ending date earned and as it stands right now that is not available, only period end date. The date earned we are looking for is the actual week ending date, which is different than the pay period begin/end dates or check date. The Date Earned could match the pay period end date for earnings from that second week of the pay cycle. Week ending date earned data is available in Fusion, but not FDI.

This field is a basic data element that is used for calculations that are necessary for our Providence Payroll Team.

User_DTLYX

I am seeing that we have our week ending date loaded into Oracle with the InputValueName2 as "Earned Date" and the week ending date is input as ScreenEntryValue2 with a date value. That is what we are looking for.

Sheila Romane

@User_DTLYX

Are you able to see the Earned Date values in FDI?