Slow Performance When Repricing During Copy Sales Order (Doc ID 1478109.1)

Last updated on DECEMBER 12, 2016

Applies to:

Oracle Order Management - Version 12.0.6 and later
Information in this document applies to any platform.
***Checked for relevance on 13-May-2014***

Symptoms

On : 12.0.6 version, Pricing, Discounting & Charges

ACTUAL BEHAVIOR
---------------
Find slow performance when copy an order and selecting Repricing feature.


EXPENSIVE SQL
-----------------

 call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 2 105.83 104.10 102 13917591 14348 3037
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 105.84 104.10 102 13917591 14348 3037


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Query order with many configuration lines
2. Select actions > copy
3. tab to pricing options
  check Re-price as of this date

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot need to wait 8-10 minutes for the copy to complete for
an order of this size. Expectation is a few minutes.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms