Before you Begin

This 30-minute tutorial shows you how to integrate Projects data with Capital. The sections build on each other and should be completed sequentially.

Background

You can integrate data for capital projects from Projects to Capital. When you create a capitalizable project in Projects, you can map both driver-based and directly-entered project expenses either partially or in full to expense accounts and asset classes in Capital, and push the data to Capital. You can allocate a project expense across multiple accounts and asset classes. You can also calculate depreciation.

What Do You Need?

An EPM Cloud Service 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 Service instance or remove the current business process.

  • Have Service Administrator access to an EPM Enterprise Cloud Service instance. The instance should not have a business process created.
  • Upload and import this snapshot into your 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.

Creating a Capitalizable Project

In this section, you add a capitalizable project for upgrading a facility. You then add project expenses.

Adding a Capitalizable Project

  1. Sign into planning with Service Administrator credentials.
  2. From the Home page. select Projects and then Project Summary.
    Project Summary card
  3. Click the Capital vertical tab.
    Capital tab
  4. In the point of view bar, click Entity.
    Point of View bar
  5. Expand US and then select Manufacturing US.
    Member Selection
  6. Click OK.
  7. In the tabs at the bottom of the page, select Project Details.
    Project Details tab
  8. Right-click a cell in the form and select Add Project from the context menu.
    Add Project option
  9. Enter the following information:
    Property Value
    Enter Project NameBoston Facility
    Enter Project Description Boston facility upgrade
    Enter Project Start Date3/01/22
    Enter Project End Date 12/30/22

    10. Your screen should match the following:
    Add Project dialog box
  10. Click Launch.
  11. At the information prompt, click OK.
    A row for the new project is added to the table. Notice that value in the Capitalizable column is Yes.
    Add Project dialog box

Entering Project Expenses

In this section, you review driver data, and then enter expense data for equipment and materials.

  1. Select the Assumptions vertical tab.
    Assumptions tab
  2. If it is not already selected, select the Standard Rates tab at the bottom of the page.
    The tab shows the rates for material for the Manufacturing US entity.
    Standard Rates
  3. Select the Standard Rates for Equipments tab at the bottom of the page.
    The tab shows the rates for equipment for the Manufacturing US entity.
    Equipment Rates
  4. Click the Expense card.
    Expense tab
  5. In the vertical tabs, click Driver Based.
    Driver Based tab
  6. In the Point of View bar, click Project.
    Point of View
  7. Expand All Project, and then Internal Projects, and then Capital Projects, and select Boston Facility.
    Member Selection
  8. Click OK.
  9. Click the arrow at the end of the Point of View bar to refresh the form.
    Go button
  10. In the tabs at the bottom of the form, select Material.
    Materials tab
  11. In Line 1, make the following selections:
    Column Value
    PhaseNo Stages
    Material Material 1
    Expense Cash Flow IncidenceSame Month
    Units 800

    Your screen should match the following:
    Material Expense
  12. Click Save.
  13. At the Information prompt, click OK.
  14. In the tabs at the bottom of the form, select Equipment.
  15. In Line 1, make the following selection:
    Column Value
    PhaseNo Stages
    Equipment Equipment 1
    Assignment Start Data3/1/22
    Assignment End Data12/30/22
    Units 100

    Your screen should match the following:
    Equipment Expense
  16. Click Save.
  17. At the Information prompt, click OK.
  18. Right-click a cell in the form, and select Calculate Expenses.
    Calculate Expenses option
  19. At the Information prompt, click OK.

Mapping and Pushing Project Expenses to Capital

In this section, you map project expenses from Projects to expense accounts and asset classes in Capital. You map both equipment and materials expense to the Acquisition Costs expense account in Capital. You map 70% of the equipment expense to the Office Equipment asset class and the remaining 30% to the Machinery and Equipment asset class. You map 100% of the materials expense to the Buildings asset class. You push the data from Projects to Capita.l

  1. Click the Project Summary card.
    Project Summary tab
  2. Select the Capital vertical tab.
    Captial tab
  3. In the tabs at the bottom of the page, select Project Capitalization.
    Project Capitlization tab
  4. In the Project drop-down list, select Boston Facility, and then click Refresh at the end of the POV bar to refresh the form data.
    Project list
  5. In the Total Project Element area, expand Total Expenses, and then Direct Expenses. Expand Total Equipment Expense and Total Material Expense.
    The expenses calculated for material and equipment for the Boston Facility project are displayed.
    Direct Expenses
  6. In the Allocate Expense to Asset table on the right side of the form, make the following selections for Line 1 (note that in the Asset Detail list you may need to scroll down and then scroll up to display the item):
    Column Value
    Project ExpensesEquipment Expense
    Capital Expenses Acquisition Costs
    Capitalization 70%
    Asset ClassOffice Equipment
    Asset Details CIP Asset 1
  7. Make the following selections for Line 2:
    Column Value
    Project ExpensesEquipment Expense
    Capital Expenses Acquisition Costs
    Capitalization 30%
    Asset Class Machinery and Equipment
    Asset Details CIP Asset 1
  8. Make the following selections for Line 3:
    Column Value
    Project ExpenseMaterial Expense
    Capital Expenses Acquisition Costs
    Capitalization 100%
    Asset ClassBuildings
    Asset Details CIP Asset 2

    Your screen should match the following:
    Line Items
  9. Hover the cursor in the upper right corner of the Allocate Expense to Asset table to display the tool bar, then click Save. (Note that the Save process may take a few moments because a business rules runs after the save.)
    Save button
  10. At the Information prompt, click OK.
    The Capitalized Expense column displays the amount calculated for each asset class based on the capitalization percentages you entered. The data has been pushed to Capital as well. The Capital Work In Progress Assets table contains line items for the asset classes. You use the table to calculate depreciation.
    Calculation Results
  11. In the Capital Work in Progress Assets table, in the In Service column for Buildings, Machinery and Equipment, and Office Equipment, enter 3/1/22 as the in-service date.
    In Service column
  12. Hover the cursor in the upper right corner of the Capital Working in Progress table to display the tool bar, then click Save.
    Save button
  13. At the Information prompt, click OK.
  14. Right-click a cell in the Buildings row of the Capital Work In Progress table and select Calculate Depreciation from the context menu. This calculates depreciation for Buildings and pushes the data to Capital.
    Calculate Depreciation option
  15. At the Information prompt, click OK.
  16. Repeat the above two steps to calculate depreciation for the Machinery and Equipment and Office Equipment rows.
    Your screen should match the following
    Calculate Depreciation option
  17. Click Home icon (Home) to return to the Home page.

Reviewing the Results in Capital

  1. From the Home page, click Capital, and then Investments.
    Capital card
  2. Click the New Asset Planning vertical tab.
    New Asset Planning tab
  3. In the tabs at the bottom of the page, select New Assets from Projects.
    New Assets from Project tab
  4. Verify that the point of view is set to Manufacturing US, USD, Plan, Working. In the CIP Assets area, verify that Boston Facility is selected for project.
    The CIP Assets area shows the data for the Buildings, Machinery and Equipment, and Office Equipment asset classes that was pushed from Projects. The Profit and Loss Impact area shows a chart of expense and depreciation information for the selected asset class. You can drill on the bars in the chart to view more detail.
    Building

Learn More