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

Last updated on FEBRUARY 24, 2022

Applies to:

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

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