My Oracle Support Banner

Slow Performance When Attempting to Add a New Project as a Non-Admin Superuser in P6 Professional Using Cloud Connect (Doc ID 2326162.1)

Last updated on MARCH 01, 2019

Applies to:

Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version and later
Primavera P6 Enterprise Project Portfolio Management - Version and later
Information in this document applies to any platform.


When attempting to add a new project using P6 Professional using the CloudConnect database where:
A) the user is a non-admin superuser, and
B) the user does not have access to all EPS locations in the database:

When the database already contains a large list of IDs which match the same name, the condition can result in a performance degradation when latency is introduced in the connection causing the application to hang when attempting to click the 'Add Project' icon to create a new project (or any method to add a new project).

Improve performance of the Add Project option by reducing the amount of requests triggered for the following SQL statement when a user does not have access to an entire:

EPS - SELECT proj_id FROM PROJECT WHERE UPPER(proj_short_name) = UPPER(:proj_short_name) AND NOT (proj_id = ####).

Using sample data:

  1. Create a large list of projects using the default project ID value
  2. Create a new user where:
    • assigned to a non-admin global profile
    • assigned to an OBS/EPS where none of the prior projects were created
  3. Login to P6 Professional via cloud connect as the new user
  4. Attempt to create a new project in the associated EPS
  5. Note the reported issue which occurs when latency is introduced in the connection
  6. Additionally, tracing SQL you will identify the behavior noted above.


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.