Slow reaction of Requisition Infotile since 18b
Summary
Since upgrade to 18b when clicking on the requisition Infoltile it may take 3 or 4 minutes to respond.Content
If you have noticed it takes a long time for the screen to load after clicking on the requisitions infotile, this is because there is a SQL bug apparently.
This is the work around that sped things up significantly for us.
If the profile POR_DISPLAY_CATEGORY_ITEM_COUNT value set to Y, we can ask them to turn off the profile option and that should fix the slow SQL issue.
PROFILE PROFILE_OPTION_VALUE
POR_DISPLAY_CATEGORY_ITEM_COUNT Y
Tagged:
1