My Oracle Support Banner

Conflict Check Query Has a Missing Join and Consequently Has Performance Issues (Doc ID 2094537.1)

Last updated on MARCH 27, 2019

Applies to:

Oracle Media Intellectual Property Management - Version 3.3.19.0 and later
Information in this document applies to any platform.

Symptoms

The user has performed the following steps which takes some time to execute and provide the details.:

1. Open Deal
2. Click on "Conflict Check" Icon. Now, we will get new "Conflict check" window.
3. Click on "View Details" of any conflict type items , its the icon visible against the item next to "Obsolete" column.

The user is also pointing out the Query (as below) and suggesting that:

1. though some of the columns are not joined but tables are selected
2. fees are getting added to get SUM, its not needed.

However, these above mentioned 2 points are giving performance hit. The delay is caused by the following query that the system runs to display the data has a reference to a table with no JOIN.

 

 

Cause

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
Symptoms
Cause
Solution
References


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