Poor Performance When Querying Order Number In The Order Organizer (Doc ID 2081890.1)

Last updated on SEPTEMBER 01, 2023

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.