Source Mappings for an Oracle ERP Cloud Source Type

Use an Oracle ERP Cloud source type when defining source period mappings between Oracle ERP Cloud and Oracle Enterprise Performance Management Cloud applications.

For example, you may need to define explicit period mappings between the EPM Planning Projects module (Projects) and Oracle Fusion Cloud Project Management (Project Management).

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 Oracle ERP Cloud.

   

4. From Connection, select the connection name associated with the Oracle ERP Cloud integration to use with the source period mapping.

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

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

7. From Mapping Type, select either Explicit or Adjustment.

   Explicit—The integration uses the Explicit period mappings defined in Data Integration to determine the source General Ledger Periods mapped to each Data Integration Period included when the integration is run. Explicit period mappings enable support of additional General Ledger data sources where periods are not defined by start and end dates.

   Adjustment—The integration uses regular period and adjustment periods. If the adjustment period does not exist, then only the regular period is processed. For more information, see Processing Oracle General Ledger Adjustment Periods in Administering Data Management for Oracle Enterprise Performance Management Cloud.

8. Click .

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

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

    Note:

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

11. In Source Period Year, specify the year associated with the source period date value.

12. In Source Period, specify the (GL) period for which you are creating source period.

13. In Target Period Name, specify the period name of the target period.

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

15. 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.

16. In Description, enter a description of the source period mapping.

17. Click Save.