My Oracle Support Banner

BICC Extraction Error ORA-29275: partial multibyte character (Doc ID 2746094.1)

Last updated on NOVEMBER 27, 2023

Applies to:

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


 On : version, Analytics

Customer is getting error when running BICC extract, BICC didn't download all transactions of payment batch created by the users.


acle.obiacm.dataExtract.DataExtractException: FscmTopModelAM.TransactionDFFBIAM.FLEX_BI_TransactionDFF_VI - Error read results - Error while fetching rows from server:
fetch failed[nQSError: 43113] Message returned from OBIS.\n[nQSError: 43119] Query Failed: \n[nQSError: 17001] Oracle Error code: 29275, message: ORA-29275: partial multibyte character\n at
OCI call OCIStmtFetch.\n[nQSError: 17012] Bulk fetch failed.\n\tat oracle.obiacm.utils.WriterUtils.readResults(\n\tat oracle.obiacm.utils.WriterUtils.extractConcurrent
(\n\tat oracle.obiacm.dataExtract.BIVOExtractTask.extractConcurrent(\n\tat oracle.obiacm.dataExtract.BIVOExtractTask.extractData(BIVOExtractTas\n\tat oracle.obiacm.dataExtract.BIVOExtractTask.doNormalExtract(\n\tat oracle.obiacm.dataExtract.BIVOExtractTask.doNormalExtract(
3)\n\tat oracle.obiacm.dataExtract.BIVOExtractTask.doDataExtract(\n\tat oracle.obiacm.dataExtract.BIVOExtractTask.doRun(\n\tat oracle.obiac\n\tat$\n\tat
eThread.execute(\n\tat\nCaused by: java.sql.SQLException: Error while fetching rows from server:


The issue can be reproduced at will with the following steps:
1.Run BICC extract, partial manifest file is created

2. After relaunching the job, this partial manifest file was worked upon

3. json log shows above error "partial multibyte error"

The issue has the following business impact:
Customer cannot provide data for invoicing partner.




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.