You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started with Redwood for Oracle Cloud HCM   Begin Now

How to create BI Publisher payroll reports that reconcile to Oracle Payroll Activity Reports

in Payroll and Global Payroll Interface (GPI) 1 comment

Summary:

Several of our BI Publisher payroll reports that have successfully reconciled to Oracle Payroll Activity Reports for the same timeframes for the past five years are no longer reconciling. Does Oracle provide documentation on the selection criteria that it applies to the tables used by the PAR?

Content (please ensure you mask any confidential information):

We have several BI Publisher payroll reports that pull from the PAY_RUN_RESULTS and PAY_RUN_RESULT_VALUES tables, as well as several other payroll tables, and these reports are no longer reconciling to Oracle payroll activity reports for the same timeframe. Our reports were not applying any selection criteria to the PAY_RUN_RESULTS table, and we resolved some of our issues by adding "where STATUS = 'P' AND P_RR.TAX_UNIT_ID is not null". However, we are still having issues with Gross Earnings. For example, I see 2 records in the PAY_RUN_RESULTS table for one employee for a particular payment date, and

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!