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 Fusion Cloud Enterprise Performance Management 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 Oracle ERP Cloud source type:

  1. From the Data Integration home page, and then from the Actions menu, then from the Setup actions drop-down, select Period Mapping.

  2. On the Period Mapping page, select the Source Mapping tab.

  3. From the Source Type drop-down, select Oracle ERP Cloud.

    Image shows the Source Mapping tab.
  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 Image shows the Add icon. and then click Add Mapping.

  9. In Source Period Key, click Image shows select period key to open the Search and Select: Period Key window. Search and select the last day of the month for the current fiscal year to be mapped from the source system. The Source Period Name, Source Period, and Source Period Year are populated by default based on the selected Source Period Key.

    Note:

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

  10. In Target Period Key, click Image shows select period key to open the Search and Select: Period Key window. This page lists all the global mapping periods that are not used in the source mappings for the source. Specify the last day of the month for the current fiscal year to be mapped to the target system. The Target Period Name, Target Period - Month, and Target Year are populated by default based on the selected Target Period Key.

  11. In Description, enter a description of the source period mapping.
  12. To delete a mapping, click the Image shows Delete icon (Delete) icon.

  13. Click Save.