My Oracle Support Banner

Order Organizer Performance Issue: Open Sales Order (Doc ID 1665810.1)

Last updated on SEPTEMBER 20, 2017

Applies to:

Oracle Order Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Transaction Entry

ACTUAL BEHAVIOR
---------------
Find a performance issue when users perform a query on 1 order in Order Organizer or Quick Order Organizer search.

EXPECTED BEHAVIOR
-----------------------
 Querying 1 order and opening it should not take longer than a couple of seconds.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Order Management Super User
2. Order Organizer (or Quick Order Organizer)
3. Enter Order Number, click 'Find', Click Open
4. Querying 1 order with 1 line and opening it takes about 40 seconds.
Performance is consistently bad.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
All Order Management users affected. Decreased productivity, increased frustration with tool.

Customer is running Gather Schema Statistics Weekly.

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
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.