Poor Performance When Querying Order Number In The Order Organizer
(Doc ID 2081890.1)
Last updated on FEBRUARY 24, 2022
Applies to:
Oracle Order Management - Version 12.1.3 to 12.1.3.3 [Release 12.1]Information in this document applies to any platform.
Symptoms
ACTUAL BEHAVIOR
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:
SQL ID: a1ffzkwmwwyw7 Plan Hash: 971569441
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 |