Payroll Validation

Question

Does anyone have a way that they validate payroll in FDI compared to fusion?

Recently we've ran into issues where payroll SA's in FDI do not tie to fusion. We've worked with Fusion team through SR's where they've supplied data fixes so that the missing transactions are picked up correctly and loaded into FDI.

We are hoping to have a way to run quick validation so that we can get ahead of the issue rather then a user noticing a discrepancy and notifying developers about it.

Sean-B-01 · Answer

Hi @Alex van Gulijk,

I figured it would come down to building reports in OTBI and validating between the two. All of our reports for payroll currently focus around costing and we've had a couple occurrences where certain payroll actions aren't being picked up from Fusion and moved into ADW.

I'll follow a path similar to yours and build two reports around validating hours and dollars for each pay period and then by pay action. Was just curious as to how others are validating payroll.

Thank you for the feedback!

Alex van Gulijk · Answer

Hi Sean,

Most of our reports in FDI are based on the Payroll Balances subject area. A common use case for us is comparing pay by pay period for a single employee—either against OTBI reports or the actual paystub in the system.

We also analyze specific Balance Groups (e.g., all balances within a deduction group) to verify whether values align for a given time period. This approach has helped us proactively catch discrepancies or identify items that were unexpectedly included or excluded.

We’ve found that building a dashboard with a date filter, Balance Group, and the associated monetary value or hours makes it easy to review data at a glance. You can enhance it further by adding filters like Business Unit, Legal Entity, Department, etc., to support more detailed comparisons.