Before you Begin

This 30 minute hands-on tutorial shows you how to integrate data between Capital and Financials. You learn how to map Capital 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 data from Capital to Financials. Asset data in Capital is summarized by asset class for each entity. You map Capital asset classes to accounts in Financials. You can map multiple asset classes to the same account in Financials, in which case the values are aggregated. For example, you could map both the Furniture and Fixtures asset class and the Office Equipment asset class to the Office Furniture and Equipment account in Financials. When data changes for new, existing, or leased assets in Capital, you can push the updated 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 Forms

    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 Capital is displayed in the Capex 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 Balance Sheet Integration Summary.
  5. Verify that the point of view is Sales US, Plan, Working, USD, FY22.
    Point of View
  6. Scroll the form to review the data in the Capex Detail column.

    The Capex Detail column shows the balance sheet data that has been pushed from Capital. Notice the current value for Computer Hardware and Equipment of 14,606 under Fixed Assets. You will be updating data for this account in a later section.

    Balance Sheet Integration Summary form
  7. Click the x on the Balance Sheet Integration Summary tab at the bottom of the page to close the form.
  8. In the list of forms, click Financial Integration Summary.
  9. Scroll the form to review the data for Repairs and Maintenance and Insurance in the Capex Detail column.
    Notice the current value for Repairs and Maintenance of 28 and Insurance of 22. You will be updating data for these accounts in a later section.
    Financials Integration Summary form
  10. Scroll the form to review the data for the Depreciation account in the Capex Detail column.
    Notice the current value for Depreciation of 5,456. You will be updating data for this account in a later section.
    Financials Integration Summary form
  11. Click the x on the Financials Integration Summary tab at the bottom of the page to close the form.
  12. Click Home Home icon to return to the Home page.

Adding a New Asset Class

When you add a new tangible or intangible asset class in Capital, you should map the data for the asset class to accounts in Financials. In this section, you add a new tangible asset class for high end servers, and enter assumptions for the asset class. In a later section you will map data for the asset class to Financials.

  1. From the Home page, click Application, then click Configure.
    Configure card
  2. In the Configure drop-down list, select Capital.
    Configuration drop-down list
  3. Click Assets to open the Assets dialog box.
  4. Select Actions, and then Add, then select Provided Members.
    Provided Members menu option
  5. Select High End Server and click OK.
    Provided Members dialog box
  6. Click Save, and then click Close.
    Save button

    Note:

    After you add a new tangible or intangible asset class, you must refresh the database.
  7. Select Actions, then Refresh Database.
    Refresh Database option
  8. Click Create.
    Create button
  9. Click Refresh Database.
    Refresh Database Button
  10. At the warning prompt, click Refresh.
    Refresh button

    After you click Refresh, the Cube Refresh dialog box is displayed. Database refresh may take 2 or 3 minutes to complete.

  11. When the database refresh is complete, click Finish, then click Close twice.
    Cube Refresh dialog box
  12. Click Home Home icon to return to the Home page.
  13. Click Capital, and then Investments.
    Investments card
  14. In the vertical tabs, click Assumptions to display the Depreciation and Amortization Assumptions page. A row for High End Server has been added.
    Assumptions page
  15. Make the following entries in the High End Server row:
    Property Value
    Useful Life5
    Depreciation Sum of Years' digits
    Depreciation ConventionProrate Actual Data
  16. Click Save.

Adding a New Asset

In this section, you add an asset to the High End Server asset class.

  1. In the vertical tabs, click New Asset Planning.
    New Asset Planning Tab
  2. In the point of view bar, for Asset Class, select High End Server, and click the Refresh button at the end of the POV bar.
    Add New Asset option
  3. Right-click in the form and select Add New Asset.
    xxx
  4. In the New Asset dialog box, enter the following properties for the new asset.
    Property Value
    DescriptionLinux Server
    Asset ID105301
    Asset CAR#CAR105301
    PriorityHigh
    Justification IT infrastructure upgrade
    Asset Units4
    Asset Rate25000
    Salvage Value0
    Capacity UOM Each
    Purchase Date1/1/2022
    In Service Data1/1/2022
    FOG CostLeave blank
    Insurance %5
    Maintenance %5
    Asset CapacityLeave blank
    Repairs %5
    LocationLocation 2
    Asset Name"Linux Server"

    Your screen should match the following:
    Add Asset dialog box
  5. Click Launch.
  6. At the Information prompt, click OK.
  7. Right-click a cell in the Total New row and select Calculate Asset to calculate new assets.
    Calculate Asset option
  8. At the Information prompt, click OK.
    Information dialog box
  9. Right click a cell in the table and select Roll Up to roll up the data for the entity.
    Roll Up option
  10. Verify that Scenario is "OEP_Plan", Version is "OEP_Working", and Entity is “Sales US”. Click Launch.
    Roll Up Capital dialog box
  11. At the Information prompt, click OK.
    Information dialog box
  12. Click Home Home icon to return to the Home page.

Mapping Capital Data to Financials Accounts

In this section, you map the data for assets in the Higher End Server asset class to accounts in Financials.

  1. From the Home page, click Application, then click Configure.
    Configure card
  2. In the Configure drop-down list, select Capital.
    Configuration drop-down list
  3. Click Map Capital Accounts to Fin Statement to open the Map Capital Account to FS page.

    4. The rows in the table show your Asset Classes. Notice that High End Server has been added as a new, unmapped row. The columns show the Financials accounts to which data for each asset class is mapped. Notice that there are separate tabs for mapping Tangible Accounts, Intangible Accounts, and Lease Accounts.
    Mapping dilaog box

    Tip:

    The accounts available in the drop down lists in the columns are the accounts from the OFS_Capex FinStmt 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_Capex FinStmt Integration hierarchy.
  4. In the High End Server row on the Tangible Accounts tab, make the following selections for each column from the drop-down list. (Note: You can type text in the search box of the list of accounts to filter the list.)
    Column Account
    Insurance Insurance
    Property, Plant, and Equipment GrossComputer Hardware and Equipment
    Maintenance Repairs and Maintenance
    RepairsRepairs and Maintenance
    FOG Expense FOG Expense
    Other Operational Costs

    Miscellaneous Expenses

    Accumulated DepreciationAccumulated Depreciation
    Proceed from Sales of Property, Plant, and EquipmentPurchase or Sale of Fixed Assets
    Cash Outflow from Capital Additions Purchase or Sale of Fixed Assets
    Cash Inflow from Funding Proceeds from Borrowings
    DepreciationDepreciation
  5. Click Save, and at the Information prompt, click OK.
  6. Select the Lease Accounts tab. Notice that your selections for High End Server for Tangible Accounts were assigned as defaults for Lease Accounts.
    Lease Accounts tab
  7. Make the following selections for the High End Server Row.
    Column Account
    Long Term Debt Long Term Debt
    Long Term Debt: Lease Obligation Capitalized Lease Obligation
    Current Portion of Lease Obligation Current Portion of Capitalized Leases
    Rent Expense - Lease Assets Rent Expense
    Interest Interest (Income)/Expense
  8. Click Save, and at the Information prompt click OK.
  9. Right-click anywhere in the table and select Synchronize.
    Synchronize option

    After you modify mapping, you must run Synchronize to update the mapping tables.
  10. In the Sync up Account mapping dialog box, modify the text for the members in the POV to match the following:
    • Scenario: "OEP_Plan"
    • Version: "OEP_Working"
    • Entity: "Sales US"

    Your screen should match the following:
    Sync up Account Mapping
  11. Click Launch.
  12. At the Information prompt, click OK.
    Information dialog box
  13. Click Close.
  14. Click Home Home icon to return to the Home page.

Pushing Data to Financials

In this section, you use the Push Data option to push data for new, existing, and leased assets from Capital to Financials.

  1. On the Home page, click Application, and then Data Exchange.
    Data Exchange Card
  2. Click the Data Maps tab at the bottom of the page
    Data Maps tab
  3. Click All Sources and select OEP_CX.
    Data Sources list
  4. Click Financial Statements Integration.
    Notice that Source is Capital and Target is Financials. The mappings here are generated automatically by the system based on the mappings you entered on the Map Capital Accounts to Fin Statement page, so you do not need to edit the integration. However, when you change account mappings, you need to run Synchronize to update the integration.
    OCX_FS Integration dialog box
  5. Click Cancel to close the integration.
  6. For Financial Statement Integration, in the Actions column, click the ellipsis (...), and then select Synchronize.
    Synchronize option
  7. At the Information prompt, click OK.
    Information dialog box

    The mappings for the Financial Statement Integration are updated with the new mappings you made on the Map Capital Accounts to Fin Statement page. Now you are ready to push the updated Capital data to your Financials accounts.
  8. For Financial Statement Integration, in the Actions column, click the ellipsis (...), and then select Push Data.
    Push Data option
  9. You are prompted whether to clear data. If you select Yes, the current data for Capital will be cleared before the new data is loaded. If you select No, the new data is merged into the existing data. Select Yes.
    Warning dialog box
  10. At the Warning prompt, click OK.
    Warning dialog box

    The integration includes a warning message because some members in the source are dynamically calculated in the target, so those members are ignored during the data push. You can optionally view the Job console for a listing of the dynamically calculated members that were ignored.
  11. Click Home Home icon to return to the Home page.
  12. On the Home page, click Financials, and then Analysis.
    Home page
  13. Click the Forms vertical tab.
    Analysis
  14. In the list of forms, click Balance Sheet Integration Summary.
  15. Verify that the point of view is Sales US, Plan, Working, USD, FY22.
    Point of View
  16. Scroll the form to review the data in the Capex Detail column.

    Notice that the value for the Computer Hardware and Equipment account has increased from 14,606 to 114,606. This reflects the additional 100,000 asset value for the new Linux servers.

    Balance Sheet Integration Summary form
  17. Click the x on the Balance Sheet Integration Summary tab at the bottom of the page to close the form.
  18. In the list of forms, click Financial Integration Summary.
  19. Scroll the form to review the data for Repairs and Maintenance and Insurance in the Capex Detail column.
    The value for the Repairs and Maintenance account has increased from 28 to 10,028 and the Insurance account from 22 to 4,119 to reflect the repair, maintenance, and insurance costs that were calculated for the new Linux severs.
    Financials Integration Summary form
  20. Scroll the form to review the data for the Depreciation account in the Capex Detail column.
    The value for the Depreciation account has increased from 5,456 to 38,789 to reflect the depreciation calculated for the new Linux severs.
    Financials Integration Summary form

Learn More