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
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