Performance Issue on Booking Order
(Doc ID 2907373.1)
Last updated on NOVEMBER 07, 2022
Applies to:
Oracle Order Management - Version 12.2.9 and laterInformation in this document applies to any platform.
Symptoms
On : 12.2.9 version, Performance Issue
ACTUAL BEHAVIOR
---------------
The average time for 20 line standard order has gone up from less than 5 secs to 18 secs for an average.
EXPECTED BEHAVIOR
-----------------------
Creating a Sales order with 20 line should not take longer
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login as Order Management responsibility
2. Open Sales Order form
3. Under the Main tab enter Line
Line 1.1 to 20.1
4. Click Book Order
tkprof output shows the most expensive query:
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 |