Monday, November 30, 2020

Download Primavera Professional from Oracle Primavera Cloud

Download and Install Primavera Professional

Oracle Primavera Cloud provides the ability to download the Primavera Professional desktop application for a Windows or macOS operating system. The Get Oracle Primavera Professional page contains instructions for selecting your operating system and downloading the application installation file.

When downloading, installing, and using Primavera Professional, consider the following:

  • Access to Primavera Professional must be enabled before you can download and install it. See Configure Boundary Security Settings for more information (Oracle Primavera Cloud Help only).
  • For Windows systems, the application is available in .zip format. For macOS systems, the format is .dmg.
  • You must have the proper privileges to install applications on your operating system. If not, contact your administrator.
  • Primavera Professional saves the previously used project and program information, as well as the server name, to the user's local directory, the location of which varies by operating system. Additional information that is stored includes, but may not be limited to, cache files and cookies.
  • An activation code can be copied from the download page and pasted into Primavera Professional. The code ensures that your instance of Primavera Professional connects to the appropriate data center for your organization.
  • You can use the same credentials to log in to both Primavera Cloud and Primavera Professional.
  • If login fails, it means that a connection to the Primavera Cloud service cannot be established. This may be due to network connectivity issues or because you are behind a corporate firewall. You can configure proxy URL settings from the login screen by doing the following:
    • On Windows systems, press Alt to display the menu toolbar. Select Help, and then select Advanced Settings to configure proxy URL settings.
    • On macOS systems, the application menu is displayed at the top of the screen. Select Help, and then select Advanced Settings to configure proxy URL settings.

To download and install Primavera Professional:

  1. In Primavera Cloud, in the header, select your username.
  2. On the User menu, select Get Primavera Professional.
  3. Select the Copy icon next to the displayed activation code to copy the code to your clipboard.
  4. In the Select an operating system list, select your operating system.
  5. Select Download to begin the file download.
  6. When the download is complete, open the file to begin the installation process.
  7. After Primavera Professional is installed, paste the activation code into the field, and then select Continue.
  8. Enter your login credentials, and then select Sign In.


Thursday, October 22, 2020

P6 Visualizer Help Version 20

1.      Open the Oracle Help Center site for Primavera P6 Professional:

2.      Click the Documentation Library link to the release of P6 Professional you are using.

3.      In the Table of Contents, click Using

4.      Under the heading “How do I get help for P6 Visualizer?” click the HTML link.  



Tuesday, September 29, 2020

How to add an end date code for resources.

You can avoid pre-populating all of the code values and just add them on the fly. First create a Code called End Date in Summary & Settings (as described above). Do not create any code values under End Date (for now). Then add End Date as a column in your Resource List grid. When you go to assign a new end date to a particular resource, you can create a code value on-the-fly at the bottom of the popup dialog. Enter ‘29-Sep-20’ as the value name and ID. See below (I’m using Department as an example code.)


Monday, September 28, 2020

S-Curve report in P6 EPPM

This report consists of a chart and a table. The chart shows Planned Labor Units on the y-axis and date on the x-axis and plots the Original Planned Labor Units, Achieved versus Plan, Additional Work and Milestone Dates. The table gives the Total Target Planned Work, Planned Work To Date, Cancelled Work To Date, Additional Work To Date, Planned Work Achieved To Date, Total Work Achieved To Date, Manhours Planned, Manhours Achieved, Lost Time Manhours To Date, Actual Percent Complete To Date, Target Percent Complete To Date, and Actual Manhours To Date.


  1. Click Reports.
  2. On the Report page:
    1. Click View and select Reports.
    2. Expand the P6Reports folder.
    3. Expand the Project folder.
    4. Click S Curve.



How to create a S-Curve in P6 Professional by TenSix Consulting

Construction & Engineering Product Documentation

Everything you want to know about the C&E product suite. 

Thursday, September 24, 2020

Change the company name in Cloud Adminstration

Manage Companies

The Manage Companies table in Primavera Administration enables you to manage companies for your applications. A company represents a logical container of users in Primavera Administration.

There are two types of companies:

  • Owner company: An owner company has been created for you. A single owner company is required by Primavera Administration. You can modify certain aspects of the owner company (including the company full name and the password policy). It is not possible to delete an owner company.
  • Partner companies: A partner company is a separate entity from the owner company that needs to access your applications. Examples of partner companies include vendors, resellers, subcontractors, suppliers, and other consultants. Partner companies are listed under the owner company on the left side of the Manage Companies page.

    When you add a partner company in Primavera Administration, you can also assign one or more applications to the company. If you assign Primavera Unifier, the partner company is also created within that application.

Click the Manage Companies tab to view the Manage Companies table.

Thursday, September 17, 2020

Error Logging Into P6 Professional "Unable to connect to the database. Please run the database configuration tool or contact your administrator" (Doc ID 2370322.1)


In this Document






Oracle Confidential INTERNAL - Do not distribute to customer (OracleConfidential).
Reason: km issue
Created from SR 3-16914810421[This section is not visible to customers.]

Applies to:

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


When user is attempting to log into P6 Professional, the following error is received:

Unable to connect to the database. Please run the database configuration tool or contact your administrator.

The user is unable to access P6 Professional, but, is able to log into P6Web.

Steps to Reproduce
1. Launch P6 Professional.
2. Enter login credentials.
3. Observe connection is not made - error is returned.




This is caused by a defect in P6 EPPM.

A defect in the POPULATE_UACCESS stored procedure causes it to create 2 UACCESS records for the same proj_id which can result in a a unique constraint violation during login to P6 Professional by a non-admin superuser.  This was determined through the following bug request - Bug 27683951 - P6 PROFESSIONAL LOGIN ERROR "UNABLE TO CONNECT - PLEASE RUN THE DATABASE CONFIG"


This issue has been resolved, and the fix has been included as of release 18.4.  The latest patchset can be downloaded from:

  • What Are The Latest Patch Sets For Primavera P6 Release 18 (Both PPM and EPPM Releases)?(Doc ID 2449247.1)

To implement the solution, please execute the following steps:

  • Download and review the README documentation and prerequisites for the Patch Set.
  • Ensure that you have taken a backup of your system before applying the recommended Patch Set.
  • Apply the Patch Set in a test environment.
  • Retest the issue.
  • Implement the solution as appropriate on other environments.

Cloud Hosted Customers

  • Enter an SR for the appropriate Solution and reference this KM as a solution to the issue.
  • Work with Support to apply patch or upgrade account.
  • After notification that upgrade, or patch install is complete, have users ensure the patch resolves the issue.
  • Approve closure of SR when the fix has been applied and verified.


Workaround Available

To workaround this defect (until P6 can be upgraded):

  1. Recreate the populate_uaccess stored procedure to prevent more than one proj_id row being created in the UACCESS table. 
  2. Remove any potential duplicate rows created in the OBSPROJ table as a result of the UACCESS stored procedure.

For low level steps to implement the workaround:

  1. Download the following script for an updated copy of the populate_uaccess stored procedure (with fix):  populate_uaccess_fix.sql
  2. Connect to the database as the schema owner (by default, ADMUSER)
  3. Execute the script to recreate the stored procedure.  Note, this script can be run against any 18.x, 17.x, 16.x, 15.x, or 8.4 database
  4. Rebuild the OBSPROJ table by completing steps outlined in the following knowledge base document - Doc id 908570.1 - How to rebuild the obsproj table


Note:  There is a 2nd article that ALSO must be run.  It contains a script by the same name (populate_uaccess_fix.sql) that should be run.  Run the populate_uaccess_fix.sql from this article, followed by the populate_access_fix.sql from Doc id 2452802.1.

After both scripts have been run, rebuild the obsproj table.

Refer to the attachment in Error 'Unable to connect to the database. Please run the database configuration tool or contact your administrator' When Logging into P6 Professional (Doc ID 2452802.1)

To BottomTo Bottom