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.


On : 12.1.3 version, Transaction Entry

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

Expect the order lines to be displayed in a few seconds

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.

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.


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

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