Sarah Dow

Practice Leader – Financial Close

The Oracle Cloud EPM April update saw a new feature Oracle Cloud EPM in Data Integration, we now have the ability to copy both Integrations & Pipelines, below is a quick guide to getting started.

Copying Integrations

To Copy a Data Integration use the ellipse on Integration you wish to copy and from the Menu select Copy

This will open the Copy window,

The New Integration name will default to the source name Suffixed with “-1”, However, you can modify the name as you wish.
Create location & Import Format check box:
- If you leave the check box Blank (screenshot a), it will copy exactly as per the source integration
- If you wish to create a New Location &/or Import format (screenshot b), Tick the check boxes, it defaults to the source integration suffixed with “-1”, modify the content as needed, Click Save

You will be returned to the main integration tab as show Below and you can see the Newly copied integration, It will copy all the Dimension Mapping, Member mapping and options etc from the source integration and you can modify Dimension mapping, Member mapping and options as needed.

Copying Pipelines

As we saw with integrations you can also copy Pipelines, from the Data Exchange tab use the ellipse on the Pipeline you wish to copy, and from the Menu select Copy

Again, like the Integration copy the name defaults the suffix of “-1”, which you can amend as needed, but the New Pipeline code suffix simply adds a “1” as you can see in the below screenshot, click Save