Performance issue in OEXOETEL when moving from Header to Line and entering item (Doc ID 1212154.1)

Last updated on NOVEMBER 18, 2016

Applies to:

Oracle Order Management - Version 11.5.10.2 to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.
Form:OEXOETEL.FMB - Quick Sales Orders
Form:OEXOEORD.FMB - Sales Orders
ConcurrentProgram:OEOIMP - Order Import
***Checked for relevance on 23-Dec-2013***


Symptoms

Performance issue in OEXOETEL when moving from Header to Line Information and entering ordered item

The following SQL has been extracted from the trace file:

SELECT 'Y'
FROM
DUAL WHERE EXISTS (SELECT 'Y' FROM OE_ORDER_HEADERS WHERE HEADER_ID <> :B3
AND SOLD_TO_ORG_ID = :B2 AND CUST_PO_NUMBER = :B1 ) OR EXISTS (SELECT 'Y'
FROM OE_ORDER_LINES WHERE HEADER_ID <> :B3 AND SOLD_TO_ORG_ID = :B2 AND
CUST_PO_NUMBER = :B1

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