X

It's All About the Platform.

Loading Custom Object Data using The File Based Loader

Guest Author

Introduction

This blog article and accompanying video is a walk through detailing how to import data into Oracle Sales Cloud using the File Based Loader (FBL). The focus here is on importing data into Custom Objects and Standard objects with custom fields. The following video illustrates the process:

Security Role Requirements

To Import and Export data the following roles are necessary:

  • Sales Administrator (ORA_ZBS_SALES_ADMINISTRATOR_JOB)
  • Master Data Management Application Administrator (ORA_ZCH_MASTER_DATA_MANAGEMENT_APPLICATION_ADMINISTRATOR_JOB)

To further understand how Job Roles and Duty roles are related have a look at this blog article written by the Oracle A-Team.

CSV Template

The columns in the CSV template are mapped when setting up an import task in the File Based Loader. Therefore the columns can be of any name as long as each column can be mapped to a field in the custom object. By definition these column names need to be unique.

File Based Loader Size Limitations

The File Based Loader has the following limitations:

  • 100,000 record import limit per batch import.
  • Maximum 5 concurrent import activities
  • Maximum file size for an import file is 250mb

Further Information

Join the discussion

Comments ( 7 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.