HOW CAN THE PEFORMANCE ISSUE BE CORRECTED WHEN RUNNING DRT CONSTRAINTS IN OM? (Doc ID 2426349.1)

Last updated on APRIL 04, 2025

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 :

SELECT 'Yes'

FROM

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!

In this Document

Goal

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