Supported Field Mapping Templates for Capital Plan Management

These tables show supported field mappings:

Create Projects from Prime to P6

This is an import business flow that support projects starting in Prime then pushed to P6. This business flow will create a new project in the destination application with project data such as Status, Dates, Owner and Planned Budget.

Note: On the P6 side a UDF needs to be created to support the Prime planned budget value. This can be done in the P6 setup utility in Gateway. For more details on the utility see the Gateway Installation and Configuration Guide.

From Prime

To P6

ProjectId

Id

ProjectName

Name

Description

Description

Status

Status

Owner

OwnerResourceId

PlannedStartDate

PlannedStartDate

PlannedFinishDate

MustFinishByDate

Planned Budget

*Planned Budget (UDF)

IntegratedType

IntegratedType

ParentEPSId

ParentEPSId

Create Projects from P6 to Prime

This is an export business flow that support projects starting P6 then pushed to Prime. This business flow will create a new project in the destination application with project data such as Status, Dates and Owner.

From P6

To Prime

Id

ProjectId

Name

ProjectName

Description

Description

Status

Status

OwnerResourceId

Owner

PlannedStartDate

PlannedStartDate

MustFinishbyDate

PlannedFinishDate

Synchronize Proposed Budget and Plan Dates from Prime to P6

This is an import business flow that supports a top down budgeting process where proposed budgets and dates are pulled from Oracle Primavera Prime and pushed to P6.

Note: If you want to use the change log functionality, you need to manually move the UDF value to the change log with a Pending status.

From Prime

To P6

ProjectId

Id

ProjectName

Name

Description

Description

Status

Status

Owner

OwnerResourceId

PlannedStartDate

PlannedStartDate

PlannedFinishDate

MustFinishByDate

ProposedBudget

*ProposedBudget (UDF)

Synchronize Planned Budget and Plan Dates from P6 to Prime

This is an export business flow that supports a bottom up budget process where planned budgets and dates are pulled from P6 and pushed to Oracle Primavera Prime.

From P6

To Prime

Id

ProjectId

Name

ProjectName

Description

Description

Status

Status

OwnerResourceId

Owner

PlannedStartDate

PlannedStartDate

MustFinishByDate

PlannedFinishDate

SummaryPlannedCost

PlannedBudget

Synchronize Approved Budget and Plan Dates from Prime to P6

This is an import business flow where approved budgets are pushed from Oracle Primavera Prime to P6.

From Prime

To P6

ProjectId

Id

ProjectName

Name

Description

Description

Status

Status

Owner

OwnerResourceId

PlannedStartDate

PlannedStartDate

PlannedFinishDate

MustFinishByDate

ProposedBudget

*ProposedBudget (UDF)

CurrentApprovedBudget

CurrentBudget

Synchronize Project Actual Cost and progress from P6 to Prime

Once the P6 project is in the execution phase, progress data such as Actual cost, schedule percent complete, and dates are transferred to Prime.

*You can modify this template to support duration or performance percent complete.

From P6

To Prime

Id

ProjectId

Name

ProjectName

Description

Description

Status

Status

OwnerResourceId

Owner

SummaryActualStartDate

ActualStartDate

SummaryActualFinishDate

ActualFinishDate

SummaryActualTotalCost

ActualCost

SummarySchedulePercentComplete

*PercentComplete

Prime Project Planned Total Cost Spread from P6

You should include all necessary spread field mappings, such as, period start/finish dates.

From P6

To Prime

PeriodType

PeriodType

StartDate

StartDate

EndDate

EndDate

Planned Total Cost

Planned Total Cost

Prime Project Actual Total Cost Spread from P6

You should include all necessary spread field mappings, such as, period start/finish dates. This is documented to just include the specific cost spread mapped from P6 to Oracle Primavera Prime.

From P6

To Prime

PeriodType

PeriodType

StartDate

StartDate

EndDate

EndDate

ActualTotalCost

ActualTotalCost

Prime Project At Completion Total Cost Spread from P6

All necessary spread field mappings must be included, such as period start/finish dates.

From P6

To Prime

PeriodType

PeriodType

StartDate

StartDate

EndDate

EndDate

AtCompletionTotalCost

AtCompletionTotalCost



Legal Notices
Copyright © 2014, 2015, Oracle and/or its affiliates. All rights reserved.

Last Published Wednesday, March 25, 2015