Performance issue in OEXOETEL when moving from Header to Line and entering item
(Doc ID 1212154.1)
Last updated on MAY 23, 2018
Applies to:Oracle Order Management - Version 188.8.131.52 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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!