Before you Begin

This 30 minute hands-on tutorial shows you how to configure Equity Pickup consolidation rules. The sections build on each other and should be completed sequentially.

Background

For legal companies that record their investments in another legal company using the equity valuation method, the cost of the investment at time of acquisition is adjusted periodically to reflect the holding company's ownership share of the profits and loses recorded by the other company. This periodic adjustment is often referred to as Equity Pickup (EPU). The Equity Pickup feature provides dimension members and business rules to calculate Equity Pickup for holding companies. The Equity Pickup adjustment for holding companies is recorded in the seeded Equity Company Income account, with a balancing entry recorded in the seeded Investment in Equity Companies - Equity Pickup account. Data for Equity Pickup is stored at the EPU member of the Data Source dimension.

Prepare Data Source graphic

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 EPM Enterprise Cloud Service. The instance should not have a business process created.
  • Upload and import this snapshot into your Financial Consolidation and Close instance.
  • Upload and import this additional snapshot into your Financial Consolidation and Close instance to add the data form used in this tutorial.
  • Save this compressed file locally and extract the data load files (.csv).
  • Note:

    For more information on uploading and importing migration snapshots, refer to the Administering Migration for Oracle Enterprise Performance Management Cloud documentation.

Enabling Equity Pickup

You enable the Equity Pickup Feature using the Setup Wizard during business process creation, or from the Configuration page afterward. Enabling the feature adds the Equity Pickup Source member to the Account dimension and the EPU member to the Data Source dimension. You enable the Equity Pickup system rule from the Consolidation process page.

  1. From the Home page, click Application, then Configuration.
    Configuration Card
  2. Click Enable Features.
    Configuration Page
  3. In the Accounts Reporting section, verify that Equity Pickup is selected. (If Equity Pickup is not selected, select it and then click Enable.)
    Equity Pickup option
  4. Click Close.
  5. Click Consolidation.
    Consolidation card
  6. Click the Consolidation Process vertical tab to display the Consolidation Process Page.
    Consolidation Process page
  7. Select the Equity Pickup row.
    Equity Pickup row
  8. In the right-side panel, verify that Equity Pickup sequence and calculation is set to Yes.

    You optionally can specify which members of the Movement dimension are used to store the calculation results for Asset and Revenue accounts. The default value is FCCS_Mvmts_NetIncome for both.

    Equity Pickup panel

Deploying the Equity Pickup rule-sets

To configure the Equity Pickup consolidation rules, you deploy the EPU - Prepare Source Data rule-set, the EPU - Reverse Holding Company Data rule-set, and one of the Consolidate EPU Source Data rule-sets. For hierarchies with holding companies at more than one level, the Consolidate EPU Data Source rule-sets calculate the upper-level holding company's Equity Pickup from the subsidiaries of a lower-level holding company, based on its ownership share in the lower-level holding company. Deploy the Consolidate EPU Source Data rule-set to include Equity Pickup detail for each subsidiary of the lower-level holding in the upper-level holding company. Select Consolidate EPU Source Data Indirect Grouping to include only a summarized value, without detail for each subsidiary. You can only deploy one of these rule-sets.

  1. In the Consolidation Process page, click Consolidated.
    Consolidated tab
  2. Click Configurable Consolidation to open the Manage Consolidation Rules dialog box.
    Configurable Consolidation option
  3. In the list of rule-sets, select Prepare Source Data, Consolidate EPU Source Data, and Reverse Holding Company Data.
    Rule-sets
  4. Click Deploy.
    Deploy button
  5. At the Information dialog box, click OK.
    Information dialog box
  6. Click Close to return to the Consolidation Process page.

Importing data

Import Ownership Information

  1. In the vertical tabs of the Consolidation Process page, click Manage Ownership.
    Manage Ownership Tab
  2. Verify the Point of View (POV) is set to Total Geography, Actual, FY18, Jan. If not, update the member selections and click Go(Go).
  3. Click Actions, then ImportOwnershipData.
    Import Ownership Data
  4. Click Browse, then select the file EPU_OwnershipLoadFile_01Jan.csv. Then click Import.
    import ownership data
  5. When complete, click OK, then Close.
    Import Status OK
  6. Review the ownership structure.

    There are two holding companies, Legal Entity 0011 and Legal Entity 0012. The ownership percentages entered for the consolidation parents (Console Entity 011 and Consol Entity 0012)) represent the holding companies ownership of their subsidiaries. Legal Entity 0012 owns 25% of Legal Entity 0014, and 10% each of Legal Entity 0016 and Legal Entity 0017. Legal entity 0011 owns 80% of Consol Entity 0012, the parent of Legal Entity 0012. Consol Entity 0012 represents the consolidated results for the Legal Entity 0012 holding company.

    Ownership Information
  7. Click Home icon (Home) to go to the home page.

Importing Translation Rates

To simplify your sample data, you import a translation rates file that sets the rate for all currencies to 1. This allows you to analyze the calculation results without considering the affect of different translation rates.

  1. On the Financial Consolidation and Close home page, click Application, then Overview.
    Home Page
  2. On the Application page, click Actions, and select Import Data.
    Actions Menu
  3. In Import Data dialog, click Create.
    Create Button
  4. Keep all the default selections, and click Browse to select a file.
    Browse Button

    Note:

    Depending on your browser, the button label may display Choose File or Browse.
  5. Locate and select EPU_FXRates_Ones.csv, and click Open.
  6. Click Import.
    Import Button
  7. At the information dialog, click OK.
    Information Prompt

    Tip:

    The data files provided in this tutorial have been validated against the loaded business process. For newly created or modified data files, Oracle recommends that you validate the files before running the import process.
  8. Click Close twice.

Import financial data

In this section, you load financial data for the Legal Entity 0012 holding company and its subsidiaries.

  1. On the Application page, click Actions, and select Import Data.
    Actions Menu
  2. In Import Data dialog, click Create.
  3. Keep all the default selections, and click Browse to select a file.
  4. Locate and select EPU_DataLoadFile.csv, and click Open.
  5. Click Import.
  6. At the information dialog, click OK.
  7. Click Close twice.
  8. Click Jobs.
    Jobs Icon
  9. Verify that the jobs completed successfully.
    Jobs Page
  10. Click Home icon (Home) to go to the home page.

Running Equity Pickup consolidation rules

In this section, you run the consolidation process and then review the calculation results. The Equity Pickup system rule and the Equity Pickup rule-sets you deployed run as part of the consolidation process.

Running consolidation rules

  1. From the Home page, click Data.
    Data card
  2. Open the Reference_Application folder, then the Equity Pickup folder, and click EP Data.
    Forms list
  3. Review the form data.
    The form shows the data you loaded for Legal Entity 0012 and its subsidiaries. The column for Total Equity > Total Movement Changes is empty because parent members for the Movement dimension are not populated until consolidation has been run.
    Form with Journals Data
  4. In the data form, right click a cell in the row for Consol Entity 0012 (USD) to display the pop-up menu, and then select Consolidate.
    Actions Menu
  5. Verify the following member information in the Consolidation dialog box, and then click Launch.
    • Entity: CE-0012-(USD)
    • Scenario: Actual
    • Period: Jan
    • Year: FY18
    Consolidation dialog box
  6. At the Information dialog box, click OK.
    Information dialog box
  7. Review the data. The Total Equity account has been populatd by the consolidation process. This is the source data for the calculations performed by the Equity Pickup rules.
    Consolidation Results
  8. Click the X in the tab for EP Data at the bottom of the page to close the form and return to the Data page.

Reviewing the calculation results

  1. Expand the Reference Application folder, and then the Equity Pickup folder, and click EP Calculations.
  2. Review the calculation results.
    1) For each subsidiary, the rules in the Prepare Data Source rule-set applied the holding company ownership percentage to the Total Equity amount, and wrote the result to the Equity Pickup Source account for the entity. Equity Pickup Source is a memo account that does not roll up in the balance sheet; it is used only as a data source for the other Equity Pickup calculations. 2) For each subsidiary, the Equity Pickup system rule wrote the amount in Equity Pickup Source to the Equity Company Income account of the holding company, using the ICP dimension to record the source entity. The rule wrote a balancing entry to the Investment in Equity Companies - Equity Pickup account. 3) The rules in the Reverse Holding Company Data rule-set then wrote reversals to the elimination member for the Equity Company Income and Investment in Equity Companies - Equity Pickup accounts , resulting in a Contribution of zero to the parent. This ensures the data is not double-counted in the consolidated results.
    Consolidation Results
  3. Click the X in the tab for EP Calculations at the bottom of the page to close the form and return to the Data page.
  4. Expand the Reference Application folder, and then the Equity Pickup folder, and click EP Multiple Holding.
  5. Review the calculation results.
    During consolidation, the Equity Pickup values in Equity Pickup Source for Legal Entity 0012 and its subsidiaries roll up to Consol Entity 0012. The upper-level holding company, Legal Entity 0011, owns 80% of Consol Entity 0012. The rules in the Consolidate EPU Data Source rule-set make an adjustment in the Elimination member to bring the Contribution amount for Equity Pickup Source to 80%. This represents Legal Entity 0011's Equity Pickup from the subsidiaries of Legal Entity 0012, due to its indirect ownership of them.
    Consolidation Results
  6. In the data form, right-click a cell in the row for Legal Entity 0011 (EUR) to display the pop-up menu, and then select Consolidate.
  7. Verify the following member information in the Consolidation dialog box, and then click Launch.
    • Entity: LE-0011-(EUR)
    • Scenario: Actual
    • Period: Jan
    • Year: FY18
    Consolidation dialog box
  8. At the Information dialog box, click OK.
  9. Review the data.
    The Equity Pickup system rule used the Contribution amount in the Equity Pickup Source account of Consol Entity 0012 to populate the Equity Company Income and Investment in Equity Companies - Equity Pickup accounts in Legal Entity 0011, the upper-level holding company, and the EPU - Reverse Holding Company Data rule-set wrote reversals to the Elimination member.
    Consolidation Results

Learn More