Invoice Statistics Job

[JitiOneWorld]

Does anyone run the R03B16-Invoice Statistics Job? If so, does the job take a long time to run? Do you run it nightly, weekly, monthly? Did you need to modify the job in any way? We have run it a couple of times every time clearing out the istc field on the correct records. When we do this, the job takes a long time (18-25 hours). Will this be the time it takes everytime or is it just the first time the job is run that it takes this long. FYI, we have approximately 2.9 million F03B11 records, 2.8 million F03B14 records, and running a SUN Enterprise 4500 with 8 processors.

OneWorld Xe on SUN Machine running Oracle 8i

 

[WSchmatz]

We run the AR statistic update (R03B16) weekly. It takes between 18-20 hours. Longer on the first run of the month.

We have 4.9 Million F03B11
5.1 Million F03B14
Running on an AS400.

I have attempted to use data selection to limit the job, but it did not work. There are some tips on the KG, but I have not found anything that sppeds it up.

If you find something, please post it.

Bill Schmatz



Bill Schmatz
Business Systems Solutions, Inc

B7332, AS400

 

[WSchmatz]

A client is running the AR statistics job weekly.

It takes between 18-20 hours. Longer on the first run of the month.

I have attempted to use data selection to reduce the time to no avail.

We have 4.9 Million F03B11 records
5.1 Million F03B14 records
running on an AS/400.

The KG has a few hints to speed it up, but none seemed to help us.

If you find something please post it.

Bill Schmatz
Business Systems Solutions, Inc

B7332, AS400

 

[jdeusa04]

Hi
Have You solved this problem? I am having the same problem while running R03B16.

Thanks
Sathish