Poor Performance When Querying Order Number In The Order Organizer
(Doc ID 2081890.1)
Last updated on SEPTEMBER 01, 2023
Applies to:
Oracle Order Management - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
When attempting to search fir an order number in the Order Organizer, the form is hanging and not returning results.
The following query is identified as having the performance issue:
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 0 0.00 0.00 0 0 0 0
Execute 2 0.00 0.00 0 0 0 0
Fetch 2 649.14 2474.15 2534376 18541363 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 4 649.14 2474.15 2534376 18541363 0 0
EXPECTED BEHAVIOR
Expect the search engine to return data in seconds.
STEPS TO REPRODUCE
1. Order Management Super User Responsibility
2. Order Organizer
3. Query a sales order
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |