How to Import Multi Select Choice List Fields through File Import Activity?

(Doc ID 1557616.1)

Last updated on MARCH 13, 2017

Applies to:

Oracle Fusion Common CRM Cloud Service - Version and later
Oracle Fusion Common CRM - Version and later
Oracle Fusion Sales Cloud Service - Version to [Release 1.0]
Oracle Fusion Sales - Version to [Release 1.0]
Information in this document applies to any platform.


Customer was trying to import a value to a multi select choice list field via a csv file through file import activity.


1.  Error : They had the values separated with a semi-colon, and the field was not populating.

     Sample part of a user's csv datafile :
     ... etc. ... MyCustomer,Y,Y,Y,0,N,"Physical Therapy;Occupational Therapy;Athletic Training",Y, ... etc ...


2.  Error:  File Import has following error message :

     The value for column FacilitySubType_c must be a value defined in the lookup type FACILITYSUBTYPES. (HZ-120113)

     Sample part of a user's csv datafile :
     ... etc. ... MyCustomer,Y,Y,Y,0,N,"""Physical Therapy,Occupational Therapy,Athletic Training""",Y, ... etc ...





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