Source Mappings for an EPM Cloud Source Type

Source Mappings can be defined when you need to add period mappings between Oracle Enterprise Performance Management Cloud business processes.

Image shows the Source Mapping tab.

Image shows the Source Mapping tab.

To create a source mapping for an EPM Cloud source type:

  1. From the Data Integration home page, and then from the Actions menu, select Period Mapping.

  2. Select the Source Mapping tab.

  3. From the Source Type drop-down, select Enterprise Performance Management.

  4. From Source Application, select the name of the source application from which to add a period mapping.

  5. From Target Application, select the name of the target application to which to add the source period mapping.

  6. Click Image shows the Add icon..

  7. From Source Period Key, specify the last day of the month for the current fiscal year to be mapped from the source system.

    Note:

    Period names cannot include spaces if used in a batch script.

  8. From Source Period Name, specify the name of the source period.

  9. In Source Period Year, specify the year associated with the source period date value.
  10. In Target Period Key, enter the last day of the month for the current fiscal year to be mapped to the target system.

    You can select another Target Period Key by clicking Image shows the Search icon. and selecting the period key from the the Search and Select: Period Key page.

  11. The Target Period Name is automatically populated by when the Target Period Key is selected.

    You can select another target period name by clicking Image shows the Search icon. and selecting another (Target) Period Key from the The Search and Select: Period Key page. This page lists all the global mapping periods that are not used in the source mappings for the source.

  12. In Target Period - Month, specify the period month of the target period.

  13. In Target Year, specify the year in which your fiscal year ends.

    For example, if your fiscal year begins in 2020 and ends in 2021, enter 2021 for all periods in the fiscal year.

  14. In Description, enter a description of the source period mapping.
  15. Click Save.