Viewing the Data Integration Home Page

Service administrators see all integrations on the Data Integration home page. When location security is enabled, Power users see only integrations assigned to the locations to which they have been granted. Otherwise, Power user can view all integrations.

Features include:

Table 3-1 Data Integration Home Page Features

Feature Description
Search

Search the list of integrations based on selected text in any of the fields.

For example, if you type File, the system returns all integrations when the name File appears in the Name, Location, Source, or Target fields.
(Sort)

Available conditions:

  • Name

  • Location

  • Source

  • Target

  • Last Executed

  • Result
Image shows the Add icon. Add a new integration or a new Pipeline.
Image shows the Delete Integration icon.

Delete an integration or pipeline.

When you select an integration to be deleted, a Delete Confirmation page displays with the following message: "Deleting the integration <integration name> will delete all related artifacts like dimension mapping, member mapping and any data loaded using the integration. Do you want to proceed?"
Image shows the Refresh icon.

Refresh the home page.
Actions menu

Provides quick access to key Data Integration functions.

Process Details—View the status and logs of a submitted integration or Pipeline. Additionally, you can reset the status of an executed job on this page. See Viewing Process Details

File Browser—Launch the File Browser from which you can navigate to the inbox, outbox, and select files. See Using the File Browser.

Setup—Common setup tasks including:

  • Applications—Gateway to integrate data between source systems and target applications, and apply business rules.
  • Period Mapping—Define and manage various kinds of calendars (for example, monthly, weekly, or daily) based on your business and statutory requirements.
  • Category Mapping—Define and manage category mappings, which enables you to categorize and map source system data to a target Scenario dimension member.
  • Query—Create and save a SQL query definition.

Configure—Commons configuration tasks:

  • System Settings—Use system settings to set, update, or clear system level options that apply to the entire system. See System Settings.

  • Security Settings—Set up location security and role security for report group options. For more information. See Setting Security Options.

  • Agent—Extract data and metadata from your on-premises data source and then load the data directly to the Oracle Fusion Cloud EPM. See EPM Integration Agent.

  • Download Agent. See Downloading the EPMAgent ZIP.

POV Period

Enables you to select and save the POV period used when running an integration. If no POV period is selected, then the system defaults to the last used period based on browser cache.

You can select another period when an unlock icon (Image shows the unlock icon. appears next to it.

(Data Integration detail)

Show the detail of each integration including:

  • Image shows Success icon.—Integration was executed successfully.
  • Image shows the Failed icon.—Integration execution failed.
  • Image shows the New Integration icon.—New Integration
  • Image shows Pending status.—Integration was processed with warnings.

(Data Integration) Name

(Data Integration) Location

Source

Target

Last Executed

Actions (…)—Go to a workflow process including:

  • General

  • Map Dimensions

  • Map Members

  • Options

  • Copy

  • Process Details

  • Workbench

(Run Integration/Pipeline) Image shows Run icon.