My Oracle Support Banner

Performance Issue in Sales Order adding lines (Doc ID 1224810.1)

Last updated on JANUARY 22, 2020

Applies to:

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

Goal

When trying to add a new line to an existing Order with around 2000 lines, system is causing performance issues.

Tkprof is showing the following as the most expensive sql

SELECT SUM(ROUND(((UNIT_SELLING_PRICE - UNIT_LIST_PRICE)* ORDERED_QUANTITY) ,:B2 )) FROM
OE_ORDER_LINES_ALL WHERE HEADER_ID = :B1 AND NVL(CANCELLED_FLAG,'N') ='N'

Solution

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
Goal
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.