1. Australia / New Zealand Payroll Implementation Guide
  2. AU Payroll History Audit Report

AU Payroll History Audit Report

You use the AU Payroll History Audit Report (R75A7703) to verify that the payroll tax history that has been generated by the payroll cycle is valid and that it does not contain any errors. This report can be run for a specific calendar year and month, or you can run the report without specifying a date to verify all existing payroll history. You can verify payroll tax history, payroll payment history or both types of history when you run the report. You can also choose to run the report for a specific company.

When you verify tax history, the report compares data in from summary tax history tables to the corresponding detail tax history tables and determines if there are any discrepancies in the data. The report compares data in these tax tables:

  • Data in the F06136 is compared to data in the F06166.

  • Data in the F06145 is compared to data in the F0719.

  • Data in the F06146 is compared to data in the F0618 and F0719.

When you verify payment history, the report compares data in from summary payment history tables to the corresponding detail payment history tables and determines if there are any discrepancies in the data. The report compares data in these payment tables:

  • Data in the F06156 is compared to data in the F06166.

  • Data in the F06156 is compared to data in the F0618.

  • Data in the F06156 is compared to data in the F0719.

Note: Oracle recommends that you run this report frequently to verify that all payroll history data is accurate and valid. Oracle also strongly suggests that you run this report and correct all errors before submitting any payroll or tax data to government reporting agencies.

This table lists the error codes that the audit report produces:

Error Code

Error Description

0000

No errors detected.

0010

Gross in F06156 not equal to Detail in PDBA Files F0618/F0719.

0011

Hours in F06156 not equal to Detail in Pay Type File F0618.

0012

Pieces in F06156 not equal to Detail in Pay Type File F0618.

0020

Taxes in F06156 not equal to Taxes in Tax Ledger File F06166.

0030

Deductions in F06156 not equal toDetail in DBA File F0719.

0040

Benefits in F06156 not equal to Detail in DBA File F0719.

0050

Cal. Month Gross F06145 not equal to Detail in DBA File F0719.

0051

Cal. Month Hours F06145 not equal to Detail in DBA File F0719.

0060

PR Month Gross in F06146 not equal to Detail in PDBA F0618/F0719.

0061

PR Month Hours in F06146 not equal to Detail in PDBA F0618/F0719.

0062

PR Month Pieces in F06146 not equal to Detail in Pay Type File F0618.

0070

Monthly Gross in F06136 not equal toDetail in Tax Ledger F06166.

0071

Monthly Excludable F06136 not equal to Detail in Tax Ledger F06166.

0072

Monthly Excess in F06136 not equal to Detail in Tax Ledger F06166.

0073

Monthly Tax in F06136 not equal to Detail in Tax Ledger F06166.

0100

No corresponding AU record found in F06136.