Manage Buyers Workload - Poor Performance
Manage Buyers Workload Search Form - Default searching takes forever to return the result. Gets following Dailogue Box - "Press Cancel to end this database operation". And even after ages if we get the result back , after Assigning the Requisition line(s) to the Buyer, the saving action also takes ages to process. I can see commit statement below (showing how many lines are saved) without any delays but above mentioned dailogue box appears and takes ages to re-query/refresh.
We have started seeing this behaviour after our upgrade to 11.2.0.2.0 from 9.2.0.8.0
Any suggestion / help will be greatly appreciated.