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.
before the Actions menu > Create Integration	Add a new integration.
before the Actions menu > Create Pipeline	Add a new pipeline.
before the Actions menu > User Settings	Update or clear user-level profiles that apply to a specific user.
Refresh	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. Locations—View all locations used in your integrations and Pipelines. 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. Other: Report Execution - View prebuilt reports that capture business-critical operations and revenue-generating activities within your organization. These reports provide key information on how data is integrated from the Enterprise Resource Planning (ERP) source system into the Oracle Fusion Cloud Enterprise Performance Management target application. System Maintenance Tasks - Run system processes to maintain and clean up all runtime artifacts, such as the Process tables, Staging tables or inbox/outbox folders.
Data Integration detail	Show the detail of each integration including: —Integration was executed successfully. —Integration execution failed. —New Integration —Integration was processed with warnings. Name Location Source Target Last Executed — Go to a workflow process including: General Map Dimensions Map Members Options Copy Process Details Workbench Delete Integration 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?" Run Integration/Pipeline