| Description |
{quote}From IC-4037:
Inventory receipt search screen - details tab is is giving the following error. JDE users are getting irritated by it since they need these to prepare different type of reporting. Also they fear that for small set of data if this can happen going forward it can cause major issues since more and more receipts will get added.
They also say that in general this screen is slow. Please work on prirority and get this addressed
{quote}We traced where it is slowing down. IC receipt tables, especially the receipt item table, have joins with the following LG views. It is used to load specific LG fields for the Detail search tab and also for the receipt item grid.
* vyuICLoadContainerPurchaseContracts
* and vyuLGLoadContainerReceiptContracts.
For example, on vyuICInventoryReceiptItemLookUp - using an old JDE db on my local with only 43 records loads initially at 1+ secs. It should be msecs.
!pastedImage_d78532_0.png!
!pastedImage_d78532_1.png!
_If you try to query on receipt item table alone, it is fast._
!pastedImage_d78532_2.png!
[~james.balachander] - can you provide us a new sql view that only loads the fields we need for IR? If we can eliminate the tables joins not needed in the LG view, it can significantly improve the performance.
|