Last updated on NOVEMBER 18, 2016
Applies to:Oracle Order Management - Version 184.108.40.206 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***
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:
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms