My Oracle Support Banner

How To Import Leads With Multiple Child Objects Records Using MULTI-CSV Method (Doc ID 2231031.1)

Last updated on DECEMBER 22, 2020

Applies to:

Oracle Fusion Marketing Cloud Service - Version and later
Information in this document applies to any platform.


Multi-CSV method is a clean and better way of import using a zip file that contains a csv file for every object you want to perform the import. In our case: Lead, Lead_Product, Lead_Contact and Lead_Resource (Lead object and its child objects).
The only condition you need to fulfil to perform this kind of import is to use the right csv file name (like in the attached to this certification) and the exact column names used in the application (API names).
This import method offers a lot of advantages: the mapping is done automatically by the application (having the same column names like API names) so you will spare the time for creating the mapping, you can include custom fields in your import files and the error log files are created separately per every object. The error zip file includes error log files per each import csv file you used.

The purpose of this import is to create lead with multiple products, multiple resources added to the Sales Team and with multiple existing contacts.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.