How To Load CSV File Type Data When Commas Exist Within The Data (Doc ID 1594828.1)

Last updated on JUNE 19, 2017

Applies to:

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

Goal

Attempting to mass load a number of customer records into Fusion CRM application.  However when commas exist within the data itself (for example, customer name or address), the record creation errors out. Errors received are:
FND-HZ_UNIQUE_IDENTIFYINGADDRESS (FND--1) Details: FND-HZ_UNIQUE_IDENTIFYINGADDRESS Cause: The message
FND-HZ_API_INVALID_FK (FND--1) Details: FND-HZ_API_INVALID_FK Cause: The message
FND-HZ_UNIQUE_SITEUSE_PRIMARY (FND--1) Details: FND-HZ_UNIQUE_SITEUSE_PRIMARY Cause: The message
FND-HZ_DE_INVALID_DATERANGE (FND--1) Details: FND-HZ_DE_INVALID_DATERANGE Cause: The message


How to load CSV file type data when commas exist within the data itself (for example, customer name or address)?
 

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