Configure the Oracle Primavera P6 EPPM Connections

This accelerator uses two connections to Oracle Primavera P6 EPPM:

1. P6 Adapter - Uses the Oracle Primavera P6 EPPM Adapter to communicate with Oracle Primavera P6 EPPM for core project and schedule data.
2. P6 REST API - Uses the REST Adapter to access the Oracle Primavera P6 EPPM REST services for supplemental data not available via the Oracle Primavera P6 EPPM Adapter.

P6 Adapter (using the Oracle Primavera P6 EPPM Adapter)

1. In the Connections section, click Actions on the connection, then select Edit.
2. In the Properties section, in the Connection URL field, enter the URL of your Primavera P6 EPPM instance.

   For example:

   https://p6.oraclecloud.com/

3. In the Security section, select the security policy you want to use (Username Password Token or OAuth).

   Enter the login credentials (user name and password) of your Oracle Primavera P6 EPPM account

4. Click Test to ensure that your connection is successfully configured. A message confirms if your test is successful.
5. Click Save. If prompted, click Save again.
6. To return to the project workspace, click Go back.

P6 REST API (using the REST Adapter)

1. In the Connections section, click Actions on the connection, then select Edit.
2. In the Properties section, do the following.
   1. In the Connection Type field, select REST API Base URL.
   2. In the Connection URL field, enter the URL of your Oracle P6 EPPM instance.

      Append your P6 REST gateway (OCI-hosted P6 uses /p6ws).

      For example: https://p6.oraclecloud.com/p6ws

3. In the Security section, do the following:
   1. In the Security Policy field, select OAuth Custom Two Legged Flow.
   2. In the Access Token Request field, enter the access token request in the following format:

      -X POST 'https://<SERVER_URL>/p6ws/oauth/token' \
          -H 'authToken: <Base64-encoded-username-and-password>' \
          -H 'return_json: true' \
          -H 'Content-Length: 0'

      Where:

      • <SERVER_URL> is the base URL of your Oracle Primavera P6 EPPM instance (for example, p6.oraclecloud.com).
      • <Base64-encoded-username-and-password> is the Base64-encoded version of your Oracle Primavera P6 EPPM user name and password. See Generate Base64-Encoded User Credentials for Access Token Requests.
4. In the Optional Security section, enter the details in the following format:
   • $access_token = access_token
   • $token_type = token_type
   • $access_token_usage = -H Authorization: ${token_type} ${access_token}
   • These fields map the JSON from the token response and instruct Oracle Integration how to pass the token.
5. Click Test to ensure that your connection is successfully configured. A message confirms if your test is successful.
6. Click Save. If prompted, click Save again.
7. To return to the project workspace, click Go back.