1. Administering Data Integration for Oracle Enterprise Performance Management Cloud
  2. Integrating Data
  3. Integrating Oracle ERP Cloud Data
  4. Selecting Period Report Parameters from the Oracle ERP Cloud

Selecting Period Report Parameters from the Oracle ERP Cloud

When importing data from the Oracle ERP Cloud, you can select the period from which to pull the data by specifying a date (using a date specific format) in the $START_PERIODKEY$ and $END_PERIODKEY$ notations.

Valid values for date format include:

  • dd: Day of the Month

  • MM or MMM: Month
  • yy or yyyy: Year

Specify the From Entered Date and To Entered Date in the format: yyyy-MM-dd. To import data from January 1, 2021 to January 31, 2021, you enter 2021-01-01 as the report parameter in the From Entered Date field and 2021-01-31 as the report parameter in the To Entered Data field.

If you want to specify a single-period load, select the $START_PERIODKEY$ notation to indicate the period key from which the data load rule is run. The data is imported for the period specified in the $START_PERIODKEY$ notation. Source period mappings are not needed for single-period loads.

You can also change the "ACCOUNTING PERIOD NAME" by selecting the actual period using the $START_PERIODKEY[MM-yy]$ format.

When you a run multi-period load, data is imported for the range and must be specified in the START_PERIODKEY and END_PERIODKEY parameter list. In order for the system to load the data into the right periods, source period mappings must exactly match the Year and Period columns in the data extract.

Multi-period imports are available if the report accepts a period as a range. If the report accepts only the period name (START_PERIODKEY parameter), no multi-period imports are available.