iProcurement has Slow Performance When Navigating to the Approval List Page at Checkout Step 2 of 3, and Gather Statistics Gets Error - Object Statistics Are Locked
Last updated on JUNE 08, 2017
Applies to:Oracle iProcurement - Version 126.96.36.199 and later
Information in this document applies to any platform.
iProcurement has slow performance when navigating to the approval list page at Requisition Checkout step 2 of 3.
TRACE shows many statements having slow performance. All of the following statements are taking from longer than 5 minutes to longer than 5 seconds to execute, and there is also a select statement with an ORA-00942 error. These should all execute much more quickly.
The following statement encountered a error during parse:
STEPS TO REPRODUCE
1. Navigate to iProcurement
2. Add one item to cart
4. Click Next to go to checkout step 2 of 3
- see the very slow performance (longer than 5 minutes)
For one case It took almost two hours to get one purchase order out, which is not acceptable. Users cannot complete the daily workload due to the system slowness. They need to get this resolved ASAP.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms