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 11.1.8.0.0 and later
Oracle Fusion Common CRM - Version 11.1.8.0.0 and later
Oracle Fusion Sales Cloud Service - Version 11.1.11.1.0 to 11.1.11.1.0 [Release 1.0]
Oracle Fusion Sales - Version 11.1.11.1.0 to 11.1.11.1.0 [Release 1.0]
Information in this document applies to any platform.

Goal

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 ...

 

 


 

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