HOW CAN THE PEFORMANCE ISSUE BE CORRECTED WHEN RUNNING DRT CONSTRAINTS IN OM?
(Doc ID 2426349.1)
Last updated on AUGUST 15, 2018
Applies to:Oracle Order Management - Version 12.1.3 to 12.2.7 [Release 12.1 to 12.2]
Information in this document applies to any platform.
Users can experience performance issues when running the DRT constraints for OM in the below queries:
Query 1 :
DUAL WHERE EXISTS ( SELECT 1 FROM OE_ORDER_LINES_ALL WHERE OPEN_FLAG ='Y'
AND INVOICE_TO_ORG_ID = :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!