Global Questions Limitation In File Import For Import Large Amount Of Data (Doc ID 1457995.1)

Last updated on AUGUST 30, 2016

Applies to:

Oracle Fusion Trading Community Model - Version 11.1.2.0.0 and later
Oracle Fusion Trading Community Model Cloud Service - Version 11.1.4.0.0 and later
Information in this document applies to any platform.

Goal

Our Customer, is exploring to import all customer data from existing source systems using the File Import functionality with the templates provided for XML generation by Oracle.
a. Can you let us know if the Templates provided for Converting CSV to XML , would scale up to accommodate importing and generating a xml file of more than 1000,000 records or more (Customer Address, Contacts , and Contacts Address and Contact Points )
b. Can the file import be used for importing such huge number of records. (i.e. for Customers, Customers Address, Customer Contact Points, Contact Profile, Contact Address and Contact Points) you could assume easily 100,000 + or more for each object.

And also do lets us know, if we have used to file import for uploading such huge extracts of data.

Do advise on other options otherwise.

Source systems in scope include - Siebel NA , EBS AR and some Home grown solutions 
( Will be considering a separate load for each system, by each object)


 

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms