My Oracle Support Banner

BI Cloud Connector Extract ORA-01555 Error FscmTopModelAM.FinGlJrnlEntriesAM.JournalLinePVO (Doc ID 2440871.1)

Last updated on FEBRUARY 28, 2022

Applies to:

Oracle Fusion General Ledger Cloud Service - Version and later
Oracle Fusion Application Toolkit - Version and later
Oracle Fusion Application Toolkit Cloud Service - Version and later
Information in this document applies to any platform.


While running the BICCC extract for Financial Analytics the following PVO is failing:


Error message:
java.lang.RuntimeException: Unable to write/upload file at oracle.obiacm.utils.WriterUtils.writeToFileAndUploadConcurrent( at oracle.obiacm.dataExtract.BIVOExtractTask.writeToFileAndUploadConcurrent( at oracle.obiacm.dataExtract.BIVOExtractTask.writeToFile( at oracle.obiacm.dataExtract.BIVOExtractTask.doNormalExtract( at oracle.obiacm.dataExtract.BIVOExtractTask.doDataExtract( at at$ at at Caused by: java.sql.SQLException: Error while fetching rows from server: fetch failed[nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 17001] Oracle Error code: 1555, message: ORA-01555: snapshot too old: rollback segment number 169 with name "_SYSSMU169_503825329$" too small at OCI call OCIStmtFetch. [nQSError: 17012] Bulk fetch failed. at at at at at oracle.obiacm.utils.WriterUtils.writeToFileAndUploadConcurrent( ... 8 more




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.