Oracle Fusion Data Intelligence Idea Lab

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Under Review
43
Views
4
Comments
User_VDYE2
User_VDYE2 Rank 1 - Community Starter

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.

5
5 votes

Under Review · Last Updated

Comments

  • Nupur Joshi-Oracle
    edited Mar 11, 2025 6:40PM

    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
    Sheila Romane Rank 1 - Community Starter

    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
    User_DTLYX Rank 1 - Community Starter

    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
    Sheila Romane Rank 1 - Community Starter

    @User_DTLYX

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