Since moving to 10x from 9x we have seen significant increases in the run times of the PR297 and PR299. Jobs that ran in 45 minutes in 9x are running approx. 3 hours in 10x. Our developers reviewed the code and found that the PR297/299 were making 15+ million reads to the new DEDGROUP table. They recommend that the jobs are updated to read the DEDGROUP table into an internal memory table once and make all subsequent reads against that internal memory table. This is how 9x worked for these jobs. We have submitted ER 59729 requesting this change to revert back to functionality that was present in 9x. We run these jobs bi-weekly for tax deposit balancing activities along with a large volume of them quarterly for tax filing/reconciliation purposes and an even larger volume annually for W-2 filing and final tax filing (with jobs for multiple locals, States and the Federal government). With the current run times we will be pushing 18-24 hours just to run all our jobs which in turn has an adverse effect on our normal nightly batch processing and our ability to timely review and balance.
We are requesting other clients in the Infor community that would feel this improvement would be beneficial to vote on this change (ER 59729). We appreciate any support we can get.
