Invoicing Performance - What is Reasonable ?

BrentHusband

BrentHusband

Member
We are running the following UBEs as part of our nightly invoicing process:
a) R42950
b) R42565 - six versions with different data selection

Total time for execution is always approximately 1.5 hours. This runtime is independent of the number of invoices waiting to be generated. Also, there are no other significant processes executing at the time of the invoicing run.

I have asked our developer to identify the files involved in case there is an opportunity for access path enhancement or purging of obsolete data.

Any tips in the interim ?


Thanks,

Brent Husband
OneWorld Xe Update 7, SP22-L1 XU7
 
Brent

I don't know much about R42950, however I do know that you need to watch F42565 which is a temporary table associated with invoice print. We have had instances where users have gone to reprint an invoice but messed up the data selection and loaded all invoices into this file for reprinting. If the job is terminated, then all the records get left in the table and you can get a performance hit. You don't say what database you are running on, but in Oracle it is possible for a table like that to get very fragmented as well. In the past I have regenerated this table when it got too bad.

Regards
Marty
 
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =



deleting records on this file. It worked great for me. Lowing the =
invoice printing time from 1 minute to 10 second per invoice.</FONT></P>















nightly invoicing process:</FONT>



hours. This runtime is independent of the number of invoices =
waiting to be generated. Also, there are no other =
significant processes executing at the time of the invoicing =

involved in case there is an opportunity for access path enhancement or =
purging of obsolete data.</FONT></P>






HREF=3D"http://www.jdelist.com/ubb/showthreaded.php?Cat=3D&Board=3DOW&Num=

stop receiving these messages, login to <A =
click Control Panel, then click Edit by "Subscribe / =
Unsubscribe from receiving board posts by email, change message =
notifications, etc." and adjust your subscription preferences. =
JDEList is not affiliated with JDEdwards=AE</FONT></P
 
Re: RE: Invoicing Performance - What is Reasonable ?

RE: Deleting records on this file....
Which file are you referring to ?
 
We are running on the AS/400 - the database is the native DB2/400.

RE: File F42565
This file is reorganized as a part of nightly processing, right before the invoicing run starts. The file does not get very big - right now there are only 800 records in it with 0 deleted records.

Thanks for the suggestion.
 
Back
Top