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 to pull detail data from tables populated by a payroll run.

Accepted answer
27
Views
3
Comments
Terri Norris
Terri Norris Rank 2 - Community Beginner
in Oracle Fusion HCM Analytics

This includes taxes, earnings and deductions.

I managed to get some of this information using OTBI and the subject Payroll Run Results Real Time, but I'm not sure all deductions are there for all employees. I also see that Earnings seem to be a total for the PPD. And taxes appear to be the amount taxes are calculated on, not the tax amount itself. Can anyone guide me either to a SQL query to pull this information or the tables to get this information from?

I am hoping for results something like this:

Person ID or # PPD start/end or Pay Date Amount Paystub designation

30000343434 3/14-3/28/25 $15.15 Dental Insurance

30000343434 3/14-3/28/25 $1500.15 Regular Earnings

30000343434 3/14-3/28/25 $45.15 Federal Taxes

Best Answer

  • Alex van Gulijk
    Alex van Gulijk Rank 3 - Community Apprentice
    Answer ✓

    If you are using FDI/FAW that information is available in the HCM - Workforce Rewards - Payroll Balances subject area. You may need to turn that feature on first and run the pipeline. If you already have it on you would want to pull in Balance Type > Balance Name which is the name of the element or balance field, and then drop in Payroll Balance Values > Balance Value as the metric. You may need to filter down Balance Dimension > Base Dimension Name first.

    Some balances won't show up unless you have configured them through the HCM UI, those instructions are located here:

    FAW : Payroll : Analytics Warehouse Balance Group Configuration — Oracle Analytics

Answers

  • MandeepGupta
    MandeepGupta Rank 8 - Analytics Strategist

    HI Terri,

    Welcome to Oracle analytics community.

    Are you trying to extract this data in Fusion HCM analytics (FDI) or in Fusion SaaS?

    The category you have choose is specific to FAW/FDI.

    Thanks.

  • Terri Norris
    Terri Norris Rank 2 - Community Beginner

    Hey all, somehow I wasn't notified I had responses, just happened to come in today and saw I had 2. Thanks so much.

    I attempted to pull the data in Fusion HCM, using OTBI after I couldn't find the tables to use for BI Publisher.

    Alex, in using your instructions, I am on the right track!!!! I was hoping to use BI Publisher vs OTBI, but I think I can make this work. I am finding Deductions, Tax withholding as well as Earnings!!!!

    Thanks so much to you both. I haven't used UNIONs with OTBI pulled into a Data Model yet, but am thinking that is what I need to do.