Understanding Tax Area Transaction History Repost
You repost tax area information to the Tax Area Transaction History table (F06148) to create a table of PDBAs by province and tax ID. You use this table to cross-reference payroll amounts to specific boxes on year-end forms. When you repost, you also ensure that all PDBAs have been properly posted and that no PDBAs were missing during the year. If you have not been posting to this table through the year, you should repost to this table before you begin the year-end processing cycle.
The repost program reads data from the Employee Transaction History table (F0618) and the DBA Transaction Detail History table (F0719) and reposts the amounts to the Tax Area Transaction History table. The F0618 table contains all of the time entry records for the year. The F0719 table contains all of the deduction, benefit, and accrual (DBA) information.
To repost, you must set up these batch programs:
Tax Area Transaction History Repost From F0618 (R77148A)
Tax Area Transaction History Repost From F0719 (R77148B)
You must set up versions of these programs with identical version names and identical data selections. If you do not set up identical version names, you will receive an error message when you try to run the repost. Failure to set up identical data selections will result in inaccurate data in the F06148 table.
The repost program replaces and appends data according to the data selection. To replace or append data, use the data selection to select the appropriate employees and the appropriate year. Only selected data is affected.
Depending on the size of the history tables, the repost programs can take from a few minutes to several hours. Oracle recommends that you run the repost programs during off-peak hours. You should not run any other payroll functions while the system is processing these programs.
The repost programs do not produce reports.
After you have reposted tax area transaction history, you can verify the data in the Tax Area Transaction History table. You can display the total PDBA amount for each employee, as well as the individual amounts that make up the total.
If you find errors in the tax area transaction history after you have reposted tax area information, correct the errors in the Employee Transaction History table or the DBA Transaction Detail History table, and run the Tax Area Transaction History Repost program (P77148A) again.