How Enterprise Performance Management Works with Project Management

You can integrate Enterprise Performance Management (EPM Planning) and Project Management to perform organizational planning and budgeting and to execute projects. With this integration, you can manage projects without any delays, duplication of effort, or manual budget validation.

Here's how the integration handles the projects.

  • Transfer approved project and budgets created in EPM Planning to Project Management.

  • Create detailed budget in Project Management.

  • Optionally use the budget approval process to validate the detailed budgets in Project Management against the strategic budgets created in EPM Planning.

  • Use actual cost amounts from Project Management in EPM Planning.

  • Portfolio manager then analyzes the budget against the actual costs in EPM Planning. Sends re-planned budgets from EPM Planning to Project Management, in another budget version, at the resource class level.

Describes the integration between EPM Planning and Project Management.

Integration Settings

You use Data Integration and Data Migration to drive the data between the two products. Data Integration enables you to set up and run the initialization process, and then apply predefined mappings from the Project Management data model to target dimensions in the EPM Planning Projects module.

Following are the details required from Project Management for the integration.

  • Setup Connection between EPM Planning and Project Management in Data Management. You must enable the EPM Planning and the integration options along with Project Management Cloud Integration, Project Reporting, and Expense.

  • Add a Smart List entry in EPM Planning for each project template in Project Management you want to associate with projects in EPM Planning. Get the list of project template through the Export Project Templates Report. The report helps to classify the project as indirect or capital.

  • Edit entity hierarchy in EPM Planning to include all project owning organizations from Project Management. The Export Project Owning Organizations Report provides the project owning organization details.

  • Financial plan types in Project Management determine how budgets are calculated. You must associate a financial plan type used in Project Management with EPM Planning when interfacing budgets.

Integration Considerations

To export a project and project budget from EPM Planning to Project Management, the project status in EPM Planning must be Approved and the project integration status must be Initial (not yet sent to Project Management) or Ready (already sent to Project Management and can be sent again in case of changes).

Integration supports only:

  • EPM Planning applications that have Hybrid Essbase enabled.

  • EPM Planning applications that use a 12 month calendar.

  • Indirect and Capital projects in EPM Planning.

  • Indirect, capital, and nonsponsored projects in Project Management. Integration doesn't support contract projects and Grants.

  • EPM Planning cubes; there is no support for custom cubes.

  • Accounting Calendar of 12 periods which includes period of 4-4-5, 5-4-4, and 4-5-4 in Project Management. The 4-4-4 Accounting Calendar isn't supported.

  • Planned expenses and actual costs at the resource class level, for example, labor, equipment, material, and other resources.

  • Actual costs and not committed cost.

Note: If you have already implemented both EPM Planning and Project Management, and have either built a custom integration or used the application independently of each other, you must reconcile the projects as a prerequisite before using this integration.