The list of locations in the location attribute on the Project page takes too long to load after upgrade to 15.4

Document ID : KB000093571
Last Modified Date : 08/05/2018
Show Technical Document Details
Issue:
On the project Edit page, when the binocular icon User-added image next to the Location attribute is clicked, it takes a long time to load the list. 
This issue is seen after the environment has been upgraded to 15.4.

 
Environment:
CA PPM 15.4 
Resolution:
With the upgrade to 15.4, the Oracle version also needs to change to support the compatibility matrix. 
The execution plan of the query that loads the Locations list will change with Oracle version change.

To fix this issue, check the Execution plan of the locations query and optimize it.

If you are a SaaS customer, the best option is to contact support and have the SaaS DBA check this for you.