F0705 purge?

Bob B

Guest
Looking for a reason why our F0705 is so HUGE - over 14.6 million records. I see no purge routine for it, nor any other discussion that it grows so large for other shops.

What are we missing, or doing wrong?
 
This table contains detail information about every employee deduction and/or benefit calculated in the payroll process.
If a typical employee has five P/R deductions and five P/R benefits each payroll cycle then the system will write ten records to the F0705 table each time you run payroll. If you run payroll twice each month then one employee will have twenty records added to this table (10 * 2 = 20). Multiply this by 1,000 employees and you have 20,000 records added every month. See how fast this table grows? These records are used to determine if a deduction or benefit has been calculated the correct number of times in a payroll month (once per month, twice per month, every pay period, etc.). Frankly, if you are concerned with the size of this table you can purge (your own process) all records not in the current calendar year as long as you are reasonably certain you have no need to go back and run a payroll cycle in the earlier years.
In my experience once a payroll year is closed and all tax filings complete it is very unlikely you will go back and re-run another payroll cycle in that year. Or, you could leave the current year plus one more year and take out everything older than that.
Oracle (actually JDE) thought about providing purge routines for payroll and never got the project off the drawing board.
 
Back
Top