Before you Begin

This 30 minute hands-on tutorial shows you how to integrate data between Projects and Financials. You learn how to map Projects data to Financials accounts, and push the data to Financials. The sections build on each other and should be completed sequentially.

Background

You can push summarized project data from Projects to Financials. When you configure Projects, you map Projects accounts to Financials accounts. You can map multiple Projects accounts to the same account in Financials. You can create global mappings that apply to all entities, or entity-specific mappings. After you enter and calculate Projects data, you can run the Rollup Projects business rule to push the summarized data to Financials.

What Do You Need?

An EPM Cloud instance allows you to deploy and use one of the supported business processes. To deploy another business process, you must request another EPM Enterprise Cloud instance or remove the current business process.

  • Have Service Administrator access to EPM Enterprise Cloud. The instance should not have a business process created.
  • Upload and import this snapshot into your Planning instance.

    • Note:

    If you run into migration errors importing the snapshot, re-run the migration excluding the HSS-Shared Services component, as well as the Security and User Preferences artifacts in the Core component. For more information on uploading and importing migration snapshots, refer to the Administering Migration for Oracle Enterprise Performance Management Cloud documentation.

Reviewing Integration Data

    The Financials Integration Summary, Balance Sheet Integration Summary, and Cash Flow Integration Summary forms included with Financials show data that has been pushed from other modules to Financials. Data pushed from Projects is displayed in the Project Detail column of the form.

  1. Login to your Planning instance with Service Administrator credentials.
  2. On the Home page, click Financials, and then Analysis.
    Home page
  3. Click the Forms vertical tab.
    Analysis
  4. In the list of forms, click Financial Integration Summary.
  5. Verify that the point of view is set to Sales US, Plan, Working, USD, FY22.
    Point of View Settings
  6. Scroll the form to review the data for Total Cost of Sales in the Project Detail column.
    Currently no data has been pushed from Projects. You will be adding cost of sales data in Projects and pushing it to Financials in a later section.
    Financials Integration Summary form
  7. Click the x on the Financials Integration Summary tab at the bottom of the page to close the form.
  8. Click Home Home icon to return to the Home page.

Mapping Data to Financials Accounts

You map Projects accounts to Financials using the Projects Financials Mapping option on the Configure page. You can map accounts globally or at the entity level. To map accounts globally, select Company Assumptions for Entity in the POV. If an account has both a global and an entity-level mapping, the entity-level mapping overrides the global mapping. If you map multiple Projects accounts to the same Financials account, the data is aggregated.

  1. From the Home page, click Application, then click Configure.
    Configure card
  2. In the Configure drop-down list, select Projects.
    Configuration drop-down list
  3. In the list of configuration items, click Projects Financials Mapping.
    The mapping dialog box is displayed. The first column shows accounts in Projects and the second column shows the Financials accounts to which they are mapped. Notice that Labor Expense is mapped to the Labor Expense account in Financials and Material Expense is mapped to the Material account. No mappings have been made for overhead accounts. The Entity is set to Sales US, so these mappings apply to the Sales US entity only.
    Projects Financials Mapping dialog box
  4. For Materials Overhead, in the Financial Mapping Column, select Overhead.
    Entries dialog box
  5. For Labor Overhead, in the Financial Mapping Column, select Overhead.
    You mapped both Material Overhead and Labor Overhead to the Overhead account in Financials, so the data for these accounts will be aggregated when pushed to Financials.
    Entries dialog box

    6. Tip:

    The accounts available in the drop down lists in the columns are the accounts from the OFS_Project Integration subhierarchy under the OFS_Cross Module Integration hierarchy in the Account dimension. If you are using a custom chart of accounts in Financials rather than the predefined chart, you should add those accounts in the OFS_Financial Accounts hierarchy to which you want to be able to map data as shared members to the OFS_Project Integration hierarchy.
  6. Click Save.
    Save button
  7. In the POV, click Entity.
    POV
  8. To define global mappings that apply to all entities, you can select the Company Assumptions member. In this tutorial we are defining entity-level mappings.
    Select a member dialog box
  9. Click Cancel to close the member selection dialog box, and then click Close to return to the Configuration page.
  10. Click Home Home icon to return to the Home page.

Adding Driver Data and Calculating Expenses

In the section you update expense data for Labor Expense and Material Expense. You then add driver data to calculate overhead for labor and materials.

  1. From the home page, click Projects, and then Expense.
    Projects card
  2. In the vertical tabs, click Assumptions.
    Assumptions tab
  3. In the tabs at the bottom of the page, click Overhead.
    xxx
  4. In the row for Materials Overhead, in the Overhead Method column, select Total Material Expense.
    Overhead Assumptions page
  5. In the row for Material Overhead, in the FY22 Overhead Rate column, enter .2.
    This calculates Material Overhead as 20% of Total Material Expense.
    Materials Overhead
  6. In the row for Labor Overhead, in the Overhead Method column, select Total Labor Expense.
  7. In the row for Labor Overhead, in the FY22 Overhead Rate column, enter .1.
    This calculates Labor Overhead as 10% of Total Labor Expense.
    Labor Overhead
  8. Click Save.
  9. Select the Direct Input vertical tab.
    Direct Input tab
  10. In the point of view, click Project.
    POV bar
  11. In the member selector dialog box, enter digital in the Search box and press Enter. Select Digital Marketing Campaign from the member list, and then click OK.
    Select a member dialog box
  12. In the POV bar, click GO to refresh the form data.
    Go button
  13. In the Line 1, Material Expense row, in the FY22 Year Total column, replace the current value with 400,000.
  14. In the Line 3, Labor Expense row, in the FY22 Year Total column, replace the current value with 200,000.
    Expense Direct Entry form
  15. Click Save.
  16. At the Information prompt, click OK.
    Information dialog box
  17. Right-click a cell in the form and select Calculate Expenses.
    Calculate Expenses option
  18. At the Information prompt, click OK.
    Information dialog box
  19. Click the Review Project Expense vertical tab.
    Review Project Expense tab
  20. Review the values in the Calculated FY22 column.
    The values you entered for Labor Expense and Material Expense, and the values calculated for Labor Overhead and Materials Overhead, are displayed. The Materials Overhead value is 80,000 (20% of 400,000). The Labor Overhead value is 20,000 (10% of 200,000).
    Review Project Expense form
  21. Click Home Home icon to return to the Home page.

Running the Rollup Projects Business Rule

In this section, you run the Rollup Projects business rule to push data from Projects to Financials.

  1. On the Home page, click Rules.
    Rules Card
  2. Click All Cubes.
    All Culbes option
  3. In the Filter dialog box, select OEP_PFP from the Cubes list, and click Apply.
    Filter dialog box
  4. Scroll the list until Rollup Projects is visible, and click Launch for Rollup Projects.
    Launch option
  5. In the Business Rules dialog box, enter the following members :
    • Currency: USD
    • Entity: Sales US
    • Scenario: Plan
    • Version: Working

    Your screen should match the following:
    Rollup Project dialog box
  6. Click Launch.
  7. At the Information dialog box, click OK.
    Information dialog box

    8. Tip:

    To enable users to update Financials with the most recent Projects data more easily, you can add the Rollup Projects rule to the right-click menu or to the Business Rules dialog box in your forms in Projects. Use the Run After Save option to automatically run the rule when they save their data. For instructions on adding business rules to forms, see Adding and Removing Rules in Forms in the Administering Planning guide.
  8. Click Home Home icon to return to the Home page.
  9. On the Home page, click Financials, and then Analysis.
    Home page
  10. If it is not already displayed, click the Forms vertical tab.
    Analysis
  11. In the list of forms, click Financial Integration Summary.
  12. Verify that the POV is set to Sales US, Plan, Working, USD, FY22.
    Point of View Settings
  13. Scroll the form to review the data under Total Cost of Sales in the Project Detail column.
    The values you entered for the Labor Expense and Material Expense accounts in Projects were pushed to the Labor Expense and Material accounts in Financials. The data calculated for the Labor Overhead and Materials Overhead accounts that you mapped to the Overhead account in Financials was aggregated and pushed to the Overhead account.
    Financials Integration Summary form

Learn More