Oracle Fusion HCM Analytics

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Fusion Data Intelligence› Oracle Fusion HCM Analytics

Categories

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

I need a SQL Query to pull Hours and Wages by Day paid.

Received Response
54
Views
3
Comments
Vicky P
Vicky P Rank 1 - Community Starter
in Oracle Fusion HCM Analytics

The Periodic Payroll Activity report list Wages and hours summarized by process Date and element. Staff are able to view the Run Results by person and by day in the Run results option, but they are unable to print or extract the view. I need an OTBI report where they can enter an person number and receive the detail of number of hours and wages for all pay code elements for each day worked. We do not have Oracle's timekeeping system. The Hours are imported from Kronos/UKG.

Answers

  • MandeepGupta
    MandeepGupta Rank 8 - Analytics Strategist

    Hi Vicky,

    Welcome to Oracle analytics community.

    Can you please specify if you are looking for this information in FAW/FDI or Fusion SaaS?

    Thanks.

  • Vicky P
    Vicky P Rank 1 - Community Starter

    Fusion Saas

    Payroll Results hours wages and day earned.txt

    I think I found the data. Just not sure how to associate the actual day earned with the hours and the wages actually paid. Looks from this query, the hours and day earned is coming from the imported timecard file as the ID associates the hours with Date.

  • Vicky P
    Vicky P Rank 1 - Community Starter

    Is it possible to get that level of Detail in FDI? Down to the Day earned?