Learn About Importing File-Based Data to Oracle Fusion Cloud Enterprise Resource Planning

If you want to import large data files from multiple business systems to Oracle Fusion Cloud Enterprise Resource Planning (ERP), Oracle provides an easy and efficient way to convert the data to the necessary file format and break large files into manageable chunks.

Enterprise resource planning systems often provide integration services for external data sources, but the practical limits on memory and data transfer make them an expensive choice for large data files. A solution for bulk data loading must address the following challenges:

1. How to read, transform, and upload files as large as 500 MB to Oracle Fusion Cloud Applications.

2. How to provide the files in the ZIP file format required by Oracle Fusion Cloud Applications.

3. How to validate that the application received the data and was able to process the transferred ZIP file.

You can use file-based data import (FBDI) templates and processes to import data into Oracle Fusion Cloud Applications. Oracle Integration provides the tools and processes to do the following:

• Format the data file
• Break the data file into manageable chunks
• Upload the files to Oracle Fusion Cloud Applications
• Verify the file transfer

In this solution, you learn how to import data into Oracle Fusion Cloud Financial Management.

Note:

The process and steps described in this solution can be used to import data into other Oracle Fusion Cloud Applications that provide FBDI templates.

Before You Begin

Review the following resources and download the relevant FBDI templates before starting the import process.

• File-Based Data Import (FBDI) for Project Management
• File-Based Data Import (FBDI) for Financials
• File-Based Data Import (FBDI) for Procurement
• File-Based Data Import (FBDI) for SCM
• Using the Oracle ERP Cloud Adapter with Oracle Integration 3

Architecture for Importing File-Based Data for ERP

The file-based data import process generates a file-based data import (FBDI) file, uploads the file to ERP, and then receives a callback from the ERP service.

You can use Oracle Integration to schedule, package, load, and report on the success of data transfers into Oracle Cloud ERP by using following architecture:

Description of the illustration import-file-based-data-architecture.png

About Required Services and Roles

You should be familiar with provisioning and using the recommended services and technologies. Importing file-based data for use in enterprise resource planning (ERP) uses the following services and technologies:

• Oracle Integration

• Oracle Fusion Cloud Enterprise Resource Planning (ERP)

These are the roles needed for each service.

Service Name: Role	Required to...
Oracle Integration: Service Developer	Create connections and create and activate integrations.
Oracle Cloud ERP: Integrations Specialist	Submit jobs to the scheduler service.
Oracle Cloud ERP: Oracle Cloud ERP-specific data access to the integration user	Access data. You must specify the specific data access roles based on the objects you want to integrate.
Oracle Cloud ERP: AttachmentsUser	Access the Attachments security group to download the log file or the output file with the ERP Integration Service. You must verify that this role is automatically assigned to the user. ESS job and output files are placed in the Attachments Security group under the Oracle WebCenter Content server).
Oracle Cloud ERP: SOAOperator	Access and manage Oracle WebLogic Server.
Oracle Cloud ERP: FND_MANAGE_CATALOG_SERVICE_PRIV	Manage the web services catalog.

See Learn how to get Oracle Cloud services for Oracle Solutions to get the cloud services you need.