Before you Begin

This 30-minute hands-on tutorial shows you how to create Configurable Consolidation rules that use year-to-date values as source values. The sections build on each other and should be completed sequentially.

Background

Financial Consolidation and Close uses a periodic data model. For both balance sheet and income statement accounts, you load the current period change in value to base-level members of the Movement dimension. For Balance sheet accounts, the current period movement amount is aggregated with Opening Balance (carried forward from the prior period Closing Balance) to calculate the current period Closing Balance. Income statement accounts do not carry forward an Opening Balance, so the current period movement and the Closing Balance are the same. For both balance sheet and income statement accounts, you can select the YTD member in the View dimension to view year-to-date movement amounts.

If required by your business calculations, you can create Configurable Consolidation rules that are sourced from an account's year-to-date movement values, rather than the current period movement value. You can apply a factor, such as %Owned, to the values, and a processing option of Add or Subtract. The calculation results are posted to the Periodic member of the View dimension and to a selected elimination member in the Data Source dimension. In the example, the source value is retrieved from the YTD member of the View dimension for Account A, and is written to the Periodic member of the View dimension for Account B. The target View member for Configurable Consolidation rules is always Periodic.

YTD Consolidation Rule Example

If you create consolidation rules that use year-to-date source values, because the year-to-date values are written to the Periodic View member, the amounts for the YTD view and for Closing Balance may not be the same as the sourced data. If required, to produce the equivalent of a year-to-date posting based on year-to-date source data, you can create a second Configurable Consolidation rule sourced from the prior period YTD values, to create a reversal.

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.

    • Note:

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

Entering Exchange Rates

In this section, you enter exchange rates for translating from British Pounds to US Dollars.

  1. From the Home page, click Data.
    Data card
  2. In the list of forms, click Enter Exchange Rates - Multi Period.
    Form list
  3. Verify that USD is selected for the Currency dimension in the POV, and enter the following rates for translating GBP for Jan, Feb, and Mar:
      Jan Feb Mar
    Average Exchange Rate .75 .75 .75
    Ending Exchange Rate .9 .9 .9
    Enter Exhange Rates form
  4. At the Results dialog box, click OK, and then click the x for the Enter Exchange Rates tab at the bottom of the page to close the form.
  5. Click Home (Home) to return to the home page.

Recompute ownership data

In this section you recompute ownership data. You need to recompute ownership data if Entity metadata has been updated since the last time ownership data was computed.

  1. From the Home page, click Application, then Consolidation.
    Consolidation Card
  2. On the Manage Ownership page, select Actions, and then Recompute Ownership Data.
    Recompute Ownership Data option
  3. Make the selections below, then click Recompute.
    • Scenario: Actual
    • Year: FY18
    • Start Period: Jan
    recompute ownership
  4. When completed, click OK.
  5. Repeat steps two through four to recompute ownership data for Feb and Mar.

Creating Configurable Consolidation rules

In this section, you create a Configurable Consolidation rule-set with a rule that populates the Intercompany Dividends account with data sourced from the YTD member of the View dimension of the Intercompany Receivable account.

  1. Click the Consolidation Process vertical tab to display the Consolidation Process page, and then click Consolidated.
    Consolidated tab
  2. Click Configurable Consolidation.
    Configurable Consolidation option
  3. Click Create Rule Set to start a new rule-set.
    Create Rule Set icon
  4. For the rule name, enter YTD Rule-Set.
  5. In the Factor list, select Specific %, the enter 100.
    Factor
  6. In the Data Set area, in the View list, select FCCS_YTD.
    View selection
  7. In the Scope area, click Create.
    Create button
  8. In the Dimension list, click Scenario.
    Dimension list
  9. In the Scenario field, enter Actual, or use the Edit button to browse to select the member.
    Scenario field
  10. Repeat steps 8 and 9 to add the following dimensions and member selections:
    • Entity: Legal Entity 0017 (GBP)
    • Account: Intercompany Receivable
    • Data Source: Level 0 descendants of Total Data Source

    Tip:

    You can use the Function selector in the Select Members dialog box to select "Level 0 descendants" for the Total Data Source member.
    Member Selections
  11. Click Save and Close to save the rule-set and return to the list of rule-sets.
    Save and Close button
  12. In the rule-set list, select YTD Rule-Set.
    YTD rule-set
  13. In the toolbar, click Create Rule.
    Create Rule icon
  14. Enter YTD Rule for the rule name.
    Rule Name
  15. Verify that Add is selected for Processing Option.
    Processing Options
  16. Click Redirect Members.
    Redirect Members
  17. In the Target Redirection area for the Account dimension, enter Dividends Receivable, or use the Edit button to browse to select the member.
  18. In the Target Redirection area for the Data Source dimension, enter Intercompany Eliminations, or use the Edit button to browse to select the member.
    Your screen should match the following:
    Member Selections
  19. Click Save and Close to return to the rule-set list.
  20. In the rule-set list, click the check box for YTD Rule-Set.
    Checkbox
  21. In the toolbar, click Deploy to deploy the rule-set.
    Deploy button
  22. At the Information dialog box click OK.
    Information dialog box
  23. Click Close to close the Manage Consolidation Rules dialog box.
  24. Click Home (Home) to return to the home page.

Running consolidation and reviewing the results

In this section, you enter data and then run consolidation. After consolidating, you review the calculation results for the Configurable Consolidation rule you created.

  1. From the Home page, click Data.
    Data card
  2. Open the Reference_Application folder, then the Consolidation_Rules folder, and click Consol Rule YTD.
    Forms list
  3. Enter the following data for the Intercompany Receivable account.
    • Jan > Entity Currency > Data Input > Periodic: 1000
    • Feb > Entity Currency > Data Input > Periodic: 1500
    • Mar > Entity Currency > Data Input > Periodic: 2000
    Data Entry
  4. Click Save.
  5. An Information dialog box is displayed. Click OK.
  6. In the data form, right-click a cell in the March column to display the pop-up menu, and then select Consolidate.
    March column
  7. Verify the following member information in the Consolidation dialog box, and then click Launch.
    • Entity: LE-0017-GBP
    • Scenario: Actual
    • Period: Mar
    • Year: FY18
    Consolidation dialog box
  8. At the Information dialog box, click OK.
    Information dialog box
  9. Review the calculation results.
    The year-to-date values in Intercompany Receivable > Data Input > YTD > Parent Currency were re-directed to Intercompany Dividends > Intercompany Eliminations > Periodic > Parent currency for Jan, Feb, and Mar. Notice that Entity Currency values were not updated for Dividends Receivable. Consolidation rule results are posted to Parent Currency only.
    Consolidation Results

    10. Note:

    Because they are aggregated from year-to-date values posted to the Periodic member, the amounts for the YTD View member and the Closing Balance member will not be the same as the sourced YTD data, unless a rule is included to post the prior period YTD value as a reversal to the same point of view. You can use the Subtract processing option in Configurable Consolidation rules to create reversals.

Learn More