My Oracle Support Banner

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.

Goal

 Users can experience performance issues when running the DRT constraints for OM in the below queries:

Query 1 :

 

SELECT 'Yes'

FROM

 DUAL WHERE EXISTS ( SELECT 1 FROM OE_ORDER_LINES_ALL WHERE OPEN_FLAG ='Y'

  AND INVOICE_TO_ORG_ID = :B1 )

 

 

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!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.