My Oracle Support Banner

Performance Issue With Masschange Update Functionally in Quick Sales Orders Form (OEXOETEL) (Doc ID 2400010.1)

Last updated on MAY 17, 2018

Applies to:

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

Symptoms

On : 12.2.6 version, Transaction Entry

ACTUAL BEHAVIOR
Observing a performance issue in the Quick Sales Order Form when using the
Mass Change functionality.

OBSERVATION
See Mass Change the following occurs:
  > 1st time take more than 5 minutes to update 5 rows.
  > If user re-does it, it takes around two minutes.
  > Re-Do again and it takes around a minute
  > After a few mass update, the time for the update is 3 seconds...

EXPECTED BEHAVIOR
Expect little to no performance issues

STEPS
1. Responsibility: Order Management Super User
2. Order Organizer > Query Order Number 10056659
3. Select and highlight all 5 lines
4. Tools > Mass Change
5. To to Shipping Tab and Change Request_Date
6. Observe the performance 5 minutes, 37 seconds
  Redo the mass update on the Request date and the update takes around 1 minute 50 seconds
  Redo again the mass update on the Request date and the update takes around 1 minute 24 seconds
  Redo again the mass update on the Request date and the update takes around 48 seconds
  Redo again the mass update on the Request date and the update takes around 3 seconds
  Redo again the mass update on the Request date and the update takes around 3 seconds
  Redo again the mass update on the Request date and the update takes around 3 seconds
7. Wait 2 hours and we redo the same test > Observe Performance; 5 minute 55 seconds
  Redo again the mass update on the Request date and the update takes around 1 minute 41 seconds
  Redo again the mass update on the Request date and the update takes around 1 minute 5 seconds
  Redo again the mass update on the Request date and the update takes around 3 seconds
  Redo again the mass update on the Request date and the update takes around 3 seconds


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!


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