3 Install and Configure the Recipe

On your Oracle Integration instance, install the recipe to deploy and configure the integration and associated resources.

  1. On the Oracle Integration Home page, in the Get Started section, click Browse store.
  2. Search for this recipe:
    Oracle Primavera Cloud — P6 EPPM | Sync Project Details
  3. After you find the recipe, click Get on the recipe card.
    A message confirms that the recipe was successfully installed, and the recipe card shows In use.
  4. Click Configure Configure icon on the recipe to configure its resources.

The project workspace opens, displaying all the resources of the recipe.

Configure the Oracle Primavera Cloud Connection

  1. In the Connections section, click the connection name: Oracle Primavera Cloud Adapter Connection
  2. In the Properties section, in the Connection URL field, enter the URL of your Oracle Primavera Cloud instance.

    For example: https://primavera.oraclecloud.com

  3. In the Security section, do the following:
    1. From the Security Policy list, select Oracle Primavera Cloud Login.
    2. In the User Name field, enter the user name of your Oracle Primavera Cloud or integration account.
    3. In the Password field, enter the password of your Oracle Primavera Cloud or integration account.
  4. In the Access type section, select Public gateway.
  5. Click Save. If prompted, click Save again.
  6. Click Test to ensure that your connection is successfully configured. In the resulting dialog, click Test again.
    A message confirms if your test is successful.
  7. To return to the project workspace, click Go back Back icon.

Configure the Oracle Primavera P6 EPPM Connections

This recipe delivers several Oracle Primavera P6 EPPM connections, all of which need to be configured for this integration.

Do the following steps for each Oracle Primavera P6 EPPM connection.

  1. In the Connections section, click one of the Oracle Primavera P6 EPPM connection names to begin configuring it.
  2. In the Properties section, in the WSDL URL field, enter the URL of the Oracle Primavera P6 EPPM Web Service WSDL for the selected connection.
    Connection Name WSDL URL
    P6 EPPM EPS Connection https://<hostname>/p6ws/services/EPSService?wsdl
    P6 EPPM UDF Type Connection https://<hostname>/p6ws/services/UDFTypeService?wsdl
    P6 EPPM Project Connection https://<hostname>/p6ws/services/ProjectService?wsdl
    P6 EPPM ProjectCodeAssignment Connection https://<hostname>/p6ws/services/ProjectCodeAssignmentService?wsdl
    P6 UDF Values Connection https://<hostname>/p6ws/services/UDFValueService?wsdl
    P6 EPPM ProjectCodesConnection https://<hostname>/p6ws/services/ProjectCodeService?wsdl
  3. In the Security section, do the following:
    1. In the Security Policy field, select Username Password Token.
    2. In the User Name field, enter the user name of the integration user account.
    3. In the Password field, enter the password of the integration user account.
  4. In the Access type section, select Public gateway.
  5. Click Save. If prompted, click Save again.
  6. Click Test to ensure that your connection is successfully configured. In the resulting dialog, click Test again.
    A message confirms if your test is successful.
  7. To return to the project workspace, click Go back Back icon.

Update Integration Properties

In order to synchronize project details, you must activate the integration and then define the following integration properties.

  1. Go to the Integrations section of the project workspace.
  2. Activate the integration.
    1. Click Actions Actions icon next to the integration, then select Activate.
    2. In the Activate integration panel, select the appropriate tracing level, then click Activate.
  3. Update the integration property values.
    1. Click Actions Actions icon next to the integration, then select Update property values.
    2. In the Update property values panel, do the following:
      1. Click to expand the EPSId property, then in the New value field, enter the project ID of the Oracle Primavera P6 EPPM EPS ID where the project needs to be created.
      2. Click to expand the Email property, then in the New value field, enter the email address of the user running the integration. Any integration notifications will be sent to this email address.
      3. Click to expand the WorkspaceCode property, then in the New value field, enter the workspace ID of the Oracle Primavera Cloud workspace where the source project exists.
      4. Click to expand the ProjectCode property, then in the New value field, enter the project ID of the Oracle Primavera Cloud project.
    3. Click Submit.

You get a confirmation message that the integration properties have been updated successfully.

Review the Lookup Table

Review the ORCL_P6_PRIMAVERA_CLOUD_PROJECT_STATUS lookup table to view the field mappings between your Oracle Primavera Cloud and Oracle Primavera P6 EPPM instances.

  1. Go to the Lookups section of the project workspace.
  2. Click the lookup named ORCL_P6_PRIMAVERA_CLOUD_PROJECT_STATUS and review the field mappings.
    Oracle Primavera P6 EPPM Oracle Primavera Cloud
    Active ACTIVE
    Inactive INACTIVE
    Planned PLANNED
    Requested PROPOSAL
    What-if PLANNED
  3. To return to the project workspace, click Go back Back icon.