Possible Performance Issues on Oracle Install

(Doc ID 2059364.1)

Last updated on APRIL 25, 2017

Applies to:

Oracle Agile PLM Framework - Version and later
Information in this document applies to any platform.


When running an advanced relationship search on PQM objects that will not complete.

The issue can be reproduced at will with the following steps:
1. Log into web client
2. Select Advance Search
3. Search Criteria: (example criteria)

Product Service Requests / Non-conformance Reports / Relationship / Corrective and preventive Actions (this is under Quality change requests)

Status > Not In > $STATUSTYPE CANCLE;Corrective Action > AND

Status > Not In > $STATUSTYPE CANCLE;Non-conformance > AND

Project Authorization > Equal To Prompt


Upgrade Database to Oracle 12c


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 hundreds of Community platforms