Updating System Activity Sheets Using Oracle Integration

You can create custom integrations in Oracle Integration and then invoke these in Unifier to get data into System activity sheets or send data from System activity sheets.

Prerequisites

  • The project/shell is configured to integrate with Oracle Integration.
  • In the Integration node of the Company Workspace, the Enable Integration field is set to Yes in the Connect tab of the Oracle Integration Cloud window.
  • A P6 Project ID or an Oracle Primavera Cloud Project ID and Primavera Cloud Workspace ID is associated with the project/shell. For more information, see the Unifier General Administration Guide.
  • The System activity sheet is set up with relevant integrations from Oracle Integration to get or send data into/from the activity sheet.
  • Ensure that you have the necessary integration permissions.

Contact your Company Administrator if the above prerequisites are not set up or enabled.

Procedure

To update data in System activity sheets using integrations from Oracle Integration:

  1. Go to the shell tab, and switch to User mode.
  2. In the left Navigator, select the Activity Manager and select the Activity Sheets node.
  3. In the right pane of the Activity Sheets, select a system activity sheet that is set up to use an integration from Oracle Integration.
  4. To get data into the activity sheet, select Get data into Activity Sheet ("").
    1. In the Get Data dialog box:
      1. Select any of the following options to get data:
        • Select All Projects to get data from all projects.
        • Enter a project ID to get data from a specific project.
      2. In the Type field, select Baseline.
      3. Perform any of the following actions:
        • Select OK to initiate the integration from Oracle Integration and bring the data into the system activity sheet.
        • Select Cancel to discontinue.
  5. To send data from the activity sheet, select Send data from Activity Sheet ("").
    1. In the Send Data dialog box:
      1. Select any of the following options to get data:
        • Select All Projects to send activity data from all projects.
        • Enter a project ID to send data from a specific project.
      2. In the Type field, select Baseline.
      3. Perform any of the following actions:
        • Select OK to initiate the integration from Oracle Integration and send data from the system activity sheet.
        • Select Cancel to discontinue.
  6. In the History tab of the system activity sheet, review the job status.
  7. To fetch and view the latest status of the Oracle Integration job, select Refresh ("") until the status displays COMPLETED.
    If the Oracle Integration job cannot be fetched, or returns an error, a corresponding message appears with guidance for the next step as follows:
    • If the Get Data job for Re-costing and Cost Sheet roll-up completes successfully, you can initiate a new Get Data job.
    • If the Get Data job completes successfully, but the status of the Activity Spread or Assignment Spread job displays RUNNING for more than 24 hours, then the job is automatically updated to a FAILED status. You can initiate a new Get Data job.
    • If the Get Data job, the Activity Spread job, and the Assignment Spread job completes successfully, but the status of the Re-cost or Cost Sheet roll-up jobs display RUNNING for more than 24 hours, those jobs are automatically updated as FAILED. You can initiate a new Get Data job.
    • If the Get Data job is initiated or running, you select Refresh ("") , and the Oracle Integration job status displays: BLOCKED, COMPLETED, FAILED, or UNKNOWN, you can initiate a new Get Data job. If the status is FAILED, select the line to view more information about the error.
    • If the Get Data job is initiated or running, you select Refresh ("") , and the Oracle Integration job status displays: SCHEDULE_WAITING, QUEUED, or PAUSED, a corresponding message displays. In this case, you cannot initiate a new Get Data job.

    Your administrator can cancel a Get Data job if the Oracle Integration job status displays any of the following: BLOCKED, PAUSED, QUEUED, SCHEDULE_PAUSED, SCHEDULE_WAITING or UNKNOWN.