My Oracle Support Banner

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

Last updated on AUGUST 26, 2020

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


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