Unable To Import Data In Custom Object Using ImportPublicService. UnsupportedEncodingException:UTF-8

(Doc ID 2215470.1)

Last updated on JULY 27, 2017

Applies to:

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

Symptoms

On : 11.1.11.1.0 version, Accounts, Contacts, Households

Unable to import data in custom object using ImportPublicService. UnsupportedEncodingException:UTF-8

Created a Top level Common custom object and as part of client requirement, data needs to be pushed from client side to OSC using ImportPublicService Webservice.

WSDL - https://[hostname]/mktImport/ImportPublicService?WSDL

To encode the CSV data, we are using "base64encode from Opinionated Geek" - https://www.opinionatedgeek.com/Codecs/Base64Encoder --- to encode CSV file into Base64 format.

using the MOS doc - "Performing File-Based Data Import Using Web Services: (Doc ID 1605219.1)" for reference.

However, the import job fails with below error
The process fails to load data into import interface tables. Cause: java.io.UnsupportedEncodingException: UTF-8 sun.nio.cs.StreamDecoder.forInputStreamReader(StreamDecoder.java:52) java.io.InputStreamReader.(InputStreamReader.java:83) oracle.apps.marketing.commonMarketing.mktImport.loader.parser.PlainTextReader.(PlainTextReader.java:39) oracle.apps.marketing.commonMarketing.mktImport.loader.parser.PlainTextReader.(PlainTextReader.java:55) oracle.apps.marketing.commonMarketing.mktImport.loader.parser.CSVReader.(CSVReader.java:30) oracle.apps.marketing.commonMarketing.mktImport.loader.stagingLoader.StagingLoader.load(StagingLoader.java:996) oracle.apps.marketing.commonMarketing.mktImport.loader.Loader.loadBatch(Loader.java:2280) oracle.apps.marketing.commonMarketing.mktImport.model.applicationModule.ImportAMImpl.loadBatch(ImportAMImpl.java:2202) sun.reflect.GeneratedMethodAccessor153429.invoke(Unknown Source) sun.reflect.Delegating





ERROR
-----------------------
The process fails to load data into import interface tables. Cause: java.io.UnsupportedEncodingException: UTF-8 sun.nio.cs.StreamDecoder.forInputStreamReader(StreamDecoder.java:52) java.io.InputStreamReader.(InputStreamReader.java:83) oracle.apps.marketing.commonMarketing.mktImport.loader.parser.PlainTextReader.(PlainTextReader.java:39) oracle.apps.marketing.commonMarketing.mktImport.loader.parser.PlainTextReader.(PlainTextReader.java:55) oracle.apps.marketing.commonMarketing.mktImport.loader.parser.CSVReader.(CSVReader.java:30) oracle.apps.marketing.commonMarketing.mktImport.loader.stagingLoader.StagingLoader.load(StagingLoader.java:996) oracle.apps.marketing.commonMarketing.mktImport.loader.Loader.loadBatch(Loader.java:2280) oracle.apps.marketing.commonMarketing.mktImport.model.applicationModule.ImportAMImpl.loadBatch(ImportAMImpl.java:2202) sun.reflect.GeneratedMethodAccessor153429.invoke(Unknown Source) sun.reflect.Delegating




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.Use Import/export WS to send a base64 encoded format of CSV file for import of Custom Object record



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