External Data Integration

Oracle Fusion Applications
Using External Data Integration Services

Table of Contents

Introduction 4
External Data Integration Services: Overview 4
Integration Points to consider 5
Locating File Import Templates: Explained 5
Prepare Data Files 6
Data Integration using Manual Flow 7
File for Import and Export: Highlights 7
File for Import and Export: Explained 8
Load Interface File for Import Process 10
Importing Data into Application Tables: Procedure 11
Flow Automation using Web Service 12
Introduction 12
Discovering Automation Service Details 12
Constructing End Point URL 13
Web Service Operations 13
Web Service Operations with parameter details 13
Operation: uploadFileToUcm 14
Operation: submitESSJobRequest 15
Operation: getEssJobStatus 16
Operation: downloadESSJobExecutionDetails 16
Troubleshooting 17
Correcting Data Upload Errors: Explained 17
Correcting Import Process Errors: Explained 17
Inbound - End to End Automation Flow Use Case: 17
Pre-requisites: 17
Flow Steps: 18
Outbound - End to End Automation Flow Use Case: 21
Pre-requisites: 21
Flow Steps: 21
Appendix 1 – Security pre-requisites needed for downloading ESS job execution details 23
Appendix 2 – Sample code for preparing data file for the inbound flow 25
Appendix 3 - Predefined Target UCM Accounts 27
Appendix 4 – ESS Job Execution Status 29
Appendix 5 – Testing Web Service using client proxy 30
Appendix 6 – Error Handling for Import jobs 35
Appendix 7 – Using XML templates to Generate Data Files 37

Introduction
External Data Integration Services: Overview
External Data integration services are used to load data into Oracle Fusion Applications from external sources such as legacy systems and third-party applications. The following are the components in the overall process:-

Templates for structuring, formatting and generating the data file according to the requirements of the target application tables.
A File based load process for loading data from