How to erase the information in an address field by import (Doc ID 2068887.1)

Last updated on JUNE 15, 2016

Applies to:

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

Symptoms

After loading account information via CSV import, the address information has been loaded in a wrong way - the address has wrong data in column Address3.

Trying to do another import with the correct data for fields address1,address2 and address3 did not delete the wrong information already loaded in address3 for the records that have no data for this field in the CSV file.

Cause

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