My Oracle Support Banner

Poor performance when entering or modifying lines on an order with thousands of order lines (Doc ID 2643228.1)

Last updated on JULY 06, 2020

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
---------------
When customer changes the Warehouse at header, or makes any other header change, or adds a new order line, and then click on Line information, it is taking 4 - 10 minutes to display the order lines

EXPECTED BEHAVIOR
-----------------------
Expect the order lines to be displayed in a few seconds

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Enter an book a new sales order with 1000 or more order lines
2. Change the warehouse on the order header, then click on the order lines tab
3. Wait 4-10 minutes for the order lines tab to be displayed
4. Add a new order line to this order already containing thousands of order lines
5. Same performance issue.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users have to wait too long to work with order lines. Customer Service Reps typically have a customer on the phone while performing this function, and it is very annoying to both the customer and the CSR to have to sit in silence waiting for the order lines to be displayed. Also, this decreases productivity of the CSR and causes an increase in operating costs.

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.