Unable To Import Data In Custom Object Using ImportPublicService. UnsupportedEncodingException:UTF-8
(Doc ID 2215470.1)
Last updated on DECEMBER 22, 2020
Applies to:
Oracle Fusion Sales Cloud Service - Version 11.1.11.1.0 and laterInformation in this document applies to any platform.
Symptoms
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |