Creating a System Activity Sheet
The System Activity Sheet (P6 or Oracle Primavera Cloud) is used to calculate ETC or EV. The Get Data option is used for System Activity Sheet.
The System Activity Sheet can be created using the following synchronizations:
- Get Activity data from P6
- Get Activity and Assignment data from P6 for EVM
- Get Activity data from Oracle Primavera Cloud using Oracle Integration
- Send Oracle Primavera Cloud Activity data to Unifier
Note: For an activity sheet, the blocks and fields on the right pane can differ based on the synchronizations.
You have the option to view activities present in a P6 or Oracle Primavera Cloud project mapped to Unifier Shell, in the Activity Sheets log, by selecting the corresponding Project ID in the Project drop-down present inside the Activity Sheet log, when you open the system activity sheet from the Activity Sheets log.
The Project drop-down will contain the list of all P6 or Oracle Primavera Cloud projects mapped to the shell and selecting a project from this drop-down will load the respective scheduling data (activities) in the Activity Sheets log.
A project in P6 or Oracle Primavera Cloud can be a current schedule project or a baseline schedule project. Over the project life span, a user can create multiple baseline projects which are mapped to a current schedule project.
While sending data from P6 or Oracle Primavera Cloud, a baseline project sheet is created for the Project baseline (and not for Primary baseline, Secondary baseline, Tertiary baseline, and so on). As a result, every project from P6 or Oracle Primavera Cloud will have a baseline project sheet and current schedule project sheet (which will have the scheduling information, that is activities, assignments, and so on).
If a P6 or Oracle Primavera Cloud project has only current schedule, the system treats the planned data in current schedule as the baseline.
The project sheets, which are created by way of integration, are grouped under a single activity sheet that can be selected to perform Earned Value (EV) analysis.
The fields related to costing can be updated in Unifier and re-costed for a resource loaded schedule.
You can assign a rate sheet to a resource-loaded project present in the Activity Sheet log, when you open the system activity sheet from the Activity Sheets log; but if you want to perform an operation at the project sheet level, you can open the activity sheet, and select the project and schedule type while working on the activity sheet.
To create a System Activity Sheet:
- Go to your project/shell and switch to User mode.
- In the left Navigator, select Activity Manager, and then select Activity Sheet.
- From the toolbar of the Activity Sheets log, click Get Data
. - In the Get Data dialog box, choose one of the following options:
- Select the All Projects field and populate the field box with all available projects. You can use the x in front of the project name to remove it from the field box.
- Click the field box to see the list of projects and then click the project that you need.
- Select the project type: Type.
You may have to scroll down, if you select all projects.
- To apply your selection and close the window, click OK.
When the Activity Sheets log opens, you will see the following additional option on the toolbar:
Send Data: Use this to send activity sheet data to the projects in P6. This will trigger the synchronizations at Gateway level.
Notes:
- To avoid discrepancy of dates and time between applications, the P6/Oracle Primavera Cloud and Unifier servers are usually located in the same time zone.
- The Send Data feature is not currently supported with Oracle Primavera Cloud through Oracle Integration.
If your administrator defined views for the System Activity Sheet and pushed them to your project/shell, these views are listed in the Manage Views dialog box of your System Activity Sheet. You can make these views visible in your System Activity Sheet, and you can change the order in which they are listed. After they are visible, you can use them to create additional custom views. You cannot edit or delete the predefined views. If the administrator pushes additional updates to the template, custom views that you created are deleted. For more information on creating and managing views for the System Activity Sheet, see Creating and Managing Views in Activity Sheets and the System Activity Sheet in the Unifier Managers User Guide.
To learn how to create a manual activity sheet, refer to the Unifier Managers User Guide.
In This Section
Last Published Friday, April 11, 2025