You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started with Redwood: Oracle Cloud SCM and Purchasing

Slow reaction of Requisition Infotile since 18b

edited Jan 30, 2019 4:28PM in Purchasing 2 comments

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 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!