Oracle Communities

Oracle Analytics and AI

Child Item

I need to pull detail data from tables populated by a payroll run.

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

Find more posts tagged with

Fusion HCM Analytics

Accepted answers

Alex van Gulijk

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

All comments

MandeepGupta

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.

Alex van Gulijk

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

Terri Norris

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.