Proper Method to Filter Inventory

Symptom: Searching for items using quick filter or regular filter in inventory and choose/edit item is slow.

Cause: When records are being filtered for the first time, Oracle has to parse thousands of lines of SQL code to generate an execution plan. The system will take longer to complete the process, for the first time only. Any subsequent filtering, without exiting out of the module, will return the result much quicker. In addition, quick filter and regular filter must be initialized separately. Hence, switching from quick filter to regular filter or vice versa will take longer to return the result for the first time.

Solution/Best Practice:

1. Stick to one type of filtering while searching for items in inventory or documents. Try not to switch between them.
2. Do not exit inventory/choose edit items until all filtering has been done. Exiting and going back to the document requires Oracle to initialize the filter routine a second time. The following examples will show what is the recommended way and what is not:

• Correct way:

1. Enter a document (i.e. receipt, voucher, PO, etc.)
2. Select choose/edit items
3. Use quick filter (or regular filter) to find an item and change the doc qty
4. Use the same type of filter as above to find the second item and change the doc qty
5. Continue to use the same type of filter to add all items
6. Select OK to return to the document

 

• Wrong way:

 

1. Enter a document (i.e. receipt, voucher, PO, etc.)
2. Select choose/edit items
3. Use quick filter (or regular filter) to find an item and change the doc qty
4. Select OK to return to the document
5. Select choose/edit items again
6. Use quick filter (or regular filter) to find the second item and change the doc qty
7. Select OK to return to the document