Skip to main content

I came across a case where a simple search in Supplier Schedule Line takes around 1 hour to return results.

We’ve investigated and narrowed down that the condition that gives the biggest performance hit is the between condition applied on ‘Created’ field.

However, further investigation showed that the supp_sched_line_tab had more than 40 million records. So, the performance hit is self-explanatory.

40 million is a way too big of a number to exist in a single table. My question is, is there a procedure to clean up older / completed Supplier Schedule Lines in apps 8?  If there is, where can I find more information on that?

 

 

Hi Charana,

 

You can in the Supplier Schedule Agreement Part set a number of schedules you would like to save. Once you reconcile a new schedule for the part where you have enetered a value, all other schedules than the number you have specified will be deleted. 

This will however only work for the schedules where you still have activity.

 

 

Reply


Terms & ConditionsCookie settings