Before you Begin

This 30-minute hands-on tutorial shows you how to create journals using translated input currencies.

Background

Translated input currency journals enable you to enter translated data as line-items in journals and post the values to an input currency member, rather than to Entity Currency. The posted data is stored at the Translated Currency Input member of the Consolidation dimension. During consolidation, if the input currency matches the currency of the entity's parent, the value is copied from the input currency member to the Parent Currency member, without translation. When you use the Translate business rule to translate to reporting currencies, if the input currency matches the reporting currency, the value is copied to the reporting currency without translation. Translated input currency values are not reverse translated to the Entity Currency member, even if the input currency matches the currency for Entity Currency.

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.

Enabling the Translated Currency Input feature

You enable the translated input currency feature using the Setup Wizard during business process creation, or from the Configuration page afterward. Enabling the feature adds the Translated Currency Input member to the Consolidation dimension. In order to enable Translated Currency Input, Journals must be enabled also, either with our without workflow.

  1. From the Home page, click Application, then Configuration.
    Configuration Card
  2. Click Enable Features.
    Configuration Page
  3. In the Additional Consolidation Members section, select Translated Currency Input.
    Translated Currency Input option
  4. Click Enable.
  5. At the Confirmation dialog box, click OK.
    Confirmation dialog box

    The enablement process may take 3 or 4 minutes.

  6. At the completion dialog box, click OK.
    Completion dialog box
  7. Sign out, and then sign back in.
    Sign out option

Creating journals Data Source members

In this section you create a data source member named DS_USD with Journal as source data type, and link it to the the USD input currency. You also add a parent member named Total Journals to organize the Journal source data type members.

Adding members

  1. On the Financial Consolidation and Close home page, click Application, then Overview.
    Overview Card
  2. Click Dimensions, then Data Source.
    Navigate to data source dimension
  3. Expand FCCS_Total Data Source, then expand TotalInputAndAdjusted.
    data source dimension member properties
  4. Click add child icon(Add Child), then click Apply.
    Add Child
  5. Enter these properties for the new member
    • Member Name: Total Journals
    • Data Storage (Default, Consol, and Rates): Dynamic Cal
  6. Click Save.
    Total Journals
  7. Move FCCS_Journal Input under Total Journals by changing its Parent Member property from FCCS_TotalInputandAdjusted to Total Journals. Once you've updated the Parent Member, click Save.
    Journal Input member
  8. Place the cursor on Total Journals.
  9. Click add child icon(Add Child), then click Apply.
  10. Add Child
  11. Enter these properties for the new member:
    • Member Name: DS_USD
    • Source Data Type: Journal
    • Source Currency Type: USD
    Data Source member
  12. Click Save.
  13. Click Cancel to close the Edit Member Properties dialog box.

Refreshing the database

  1. Select Actions, then Refresh Database.
    Actions then Refresh Database
  2. Click Create, then click Refresh Database.
    Refresh Database Button
  3. Click Refresh.
    Refresh Button
  4. When completed click Finish.
    Finish
  5. Click Close, then click Close again.
  6. Click Home icon (Home) to return to the home page.

Recomputing ownership data

After updating metadata, you may need to refresh the ownership information in the Consolidation page.

  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. Click Home icon (Home) to return to the home page.

Entering translation rates

  1. From the Home page, click Data.
    Data card
  2. In the list of forms, click Enter Exchange Rates - Single Period.
    Form list
  3. Verify that the POV is set to Jan, FY18, Actual, and then enter the following rates for CAD to USD:
    • Average: .5
    • Ending: .75
    Enter Exhange Rates form
  4. Click Save.
  5. At the Results dialog box, click OK, and then click the x on the Enter Exchange Rates - Single Period tab at the bottom of the page to close the form.
  6. Click Home icon (Home) to return to the home page.

Creating Translated Currency Input journals

Opening periods

  1. From the Home page, click Application, and then Manage Periods.
    Manage Periods card
  2. In the POV, verify that Scenario is Actual and Year is FY18.
    Manage Periods
  3. In the Jan row, click the Actions icon and select Open to change the Period status to Opened.
    Open Period
  4. Click Home icon (Home) to return to the home page.

Creating standard and translated input currency journals

In this section, you create a standard local currency journal that uses the Journal Input Data Source member and the Entity Input Consolidation member. You then create a translated currency input journal that uses the DS_USD Data Source member and the Translated Currency Input Consolidation member. You enter the line-items for this journal in the parent's currency.

  1. Click Journals to open the Manage Journals page.
    Journals card
  2. Verify that the POV is set to Actual, FY18, Jan, Periodic, Entity Input.
    Manage Journals POV
  3. Click Create to start a new journal.
    Create button
  4. Enter the following journal details:
    • Label: Cash Adjs Std
    • Journal Type: Regular
    • Data Source: Journal Input
    Journal Detaisl
  5. Click Create to add a blank journal line item.
    line-item
  6. Enter the following member information. You can type the member names in the field or click the Action menu for the row and select Pick Members to browse the member hierarchy.
    • Entity: Legal Entity 0014 (CAD)
    • Account: Cash
    • Intercompany: No Intercompany
    • Movement: Changes in Cash
    • Multi-GAAP: Local GAAP
    • Product: No Product
    Line-Item
  7. Click Create to add another journal line item. The member information is inherited from the existing line-item. Change the Account member in the new line-item from Cash to Bank1.
  8. Enter 1000 in the Debit field for Cash and 1000 in the Credit field for Bank1.
    Completed Line Items
  9. Click Save, and then click Close.
    Save button
  10. In the row for the Cash Adjs STD journal, click the Actions icon and select Post from the menu.
    Post Journal
  11. In the Post dialog box, click Post.
    Post dialog box

    The status of the Cash Adjs Std journal on the Manage Journals page changes to Posted.

  12. In the Manage Journal POV, click Consolidation. In the Select A Member dialog box, select Translated Currency Input (it is under the Entity Total parent) and click OK.
    Select a Member dialog box
  13. Click Go icon (Go) to update the POV.
  14. Journals created under this POV will be posted to the Translated Currency Input member of the Consolidation dimension.

    Journal POV
  15. Click Create to start a new journal.
    Create button
  16. Enter the following journal details:
    • Label: Cash Adjs Parent Cur
    • Journal Type: Regular
    • Data Source: DS_USD

    Notice that the currency for the journal is set to USD automatically. You assigned this currency to the DS_USD member in the Data Source dimension metadata.

    Journal Details

  17. Click Create to add a blank journal line item.
  18. Enter the following member information. You can type the member names in the field or click the Action menu for the row and select Pick Members to browse the member hierarchy.
    • Entity: Legal Entity 0014 (CAD)
    • Account: Cash
    • Intercompany: No Intercompany
    • Movement: Changes in Cash
    • Multi-GAAP: Local GAAP
    • Product: No Product
  19. Click Create to add another journal line item. The member information is inherited from the existing line-item. Change the Account member in the new line-item from Cash to Bank1.
  20. Enter 750 in the Debit field for Cash and 750 in the Credit field for Bank1.
    Line Items
  21. Click Save, and then click Close.
  22. In the row for the Cash Adjs Parent Cur journal, click the Actions icon and select Post from the menu.
  23. In the Post dialog box, click Post.

    The status of the Cash Adjs Parent Cur journal on the Manage Journals page changes to Posted.

Viewing Translated Currency Input data

In this section, you open a form that displays journals data for the Cash account. You compare the entries created by the standard journal to those created by the translated input currency journal.

  1. Click Data.
    Data card
  2. Open the Input Currency Adjustments folder and click Translated Currency Input.
    Forms list
  3. Scroll the columns until the Journal Input and DS_USD columns for the Data Source dimension are visible and review the journal data.

    The form shows journals data for the Cash account. The 1000 from the Cash Adjs Std journal was posted to the Entity Currency member of the Currency dimension for the Journal Input Data Source member and the Entity Input member of the Consolidation dimension. The 750 from the Cash Adjs Parent Cur journal was posted to the USD input currency member of the Currency dimension for the DS_USD Data Source member and the Translated Currency Input member of the Consolidation dimension.

    Form with Journals Data
  4. From the Actions menu, select Business Rules.
    Actions Menu
  5. In the list of rules, click Consolidate.
    Business Rules dialog box
  6. Enter the following member information, and then click Launch.
    • Entity: Legal Entity 0014 (CAD)
    • Scenario: Actual
    • Period: Jan
    • Year: FY18
    Consolidation dialog box
  7. At the Information dialog box, click OK.
  8. Click Refresh to refresh the form data.
  9. Scroll the columns until the Journal Input and DS_USD columns for the Data Source dimension are visible and review the journal data.

    For the Journal Input Data Source member, the 1000 in Entity Input > Changes in Cash > Entity Currency was translated by the average rate ( .5 ) to Entity Input > Changes in Cash > Parent Currency, resulting in a value of 500. The system-defined foreign exchange calculation made an adjustment of 250. in order to adjust the translated value for Closing Balance to the ending rate ( .75 ), resulting in a Entity Input > Closing Balance > Parent Currency value of 750.

    For the DS_USD Data Source member, the 750 in Translated Input Currency > Changes in Cash > USD was copied to Translated Input Currency > Changes in Cash > Parent Currency without translation. The system-defined foreign exchange calculation was not applied, so the value in Translated Input Currency > Closing Balance> Parent Currency is also 750.

    Consolidation Results
  10. From the Actions menu, select Business Rules.
  11. In the list of rules, click Translate.
  12. Enter the following member information, then click Launch.
    • Reporting Currency: USD_Reporting
    • Entity: Legal Entity 0014 (CAD)
    • Scenario: Actual
    • Period: Jan
    • Year: FY18
  13. At the Information dialog box, click OK.
  14. Scroll the columns until the Journal Input and DS_USD columns for the Data Source dimension are visible and review the journal data. The reporting currency column is the USD column to the right of the Parent Currency column. (If data is not displayed for reporting currency, you may need to click Refresh.)

    For the Journal Input Data Source member, the 1000 in Entity Input > Changes in Cash > Entity Currency was translated by the average rate of .5 to Entity Input > Changes in Cash > USD_Reporting for a value of 500. The system defined foreign exchange calculation made an adjustment of 250 to bring the translated value to the ending rate of .75, resulting in a Entity Input > Closing Balance > USD_Reporting value of 750 .

    For the DS_USD Data Source member, the 750 in Translated Input Currency > Changes in Cash > USD was copied to Translated Input Currency > Changes in Cash > USD_Reporting without translation. The system-defined foreign exchange calculation was not applied, so the Translated Input Currency > Closing Balance> USD value is also 750.

    Translated Results

Learn More