BICC GL Balance and Journal Extract Performance Issue (Doc ID 2774020.1)

Last updated on AUGUST 01, 2023

Applies to:

Symptoms

Oracle Business Intelligence Cloud Connector (BICC) is being used to to extract Balances and Journals from Fusion General Ledger and performance issues are observed considering the volume of data.  Also, if filters are removed, the job is timing out (see error message below).

ERROR
-----------------------
FscmTopModelAM.FinGlInquiryBalancesAM.BalancePVO | 35893 | 51 | 4 | 36001 | 3175000 | FAILURE | oracle.obiacm.dataExtract.DataExtractException: FscmTopModelAM.FinGlInquiryBalancesAM.BalancePVO - Error read results - Error while fetching rows from server: java.io.IOException: end of file
at oracle.obiacm.utils.WriterUtils.readResults(WriterUtils.java:407)
at oracle.obiacm.utils.WriterUtils.extractConcurrent(WriterUtils.java:306)
at oracle.obiacm.dataExtract.BIVOExtractTask.extractConcurrent(BIVOExtractTask.java:725)
at oracle.obiacm.dataExtract.BIVOExtractTask.extractData(BIVOExtractTask.java:639)
at oracle.obiacm.dataExtract.BIVOExtractTask.doNormalExtract(BIVOExtractTask.java:299)
at oracle.obiacm.dataExtract.BIVOExtractTask.doNormalExtract(BIVOExtractTask.java:253)
at oracle.obiacm.dataExtract.BIVOExtractTask.doDataExtract(BIVOExtractTask.java:135)
at oracle.obiacm.dataExtract.BIVOExtractTask.doRun(BIVOExtractTask.java:104)
at oracle.obiacm.dataExtract.AbstractCancellableTask.run(AbstractCancellableTask.java:37)
at weblogic.work.j2ee.J2EEWorkManager$WorkWithListener.run(J2EEWorkManager.java:184)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:378)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:307)
Caused by: java.sql.SQLException: Error while

STEPS TO REPRODUCE

------------------------

See <Note 2319327.1> Fusion Applications - Business Intelligence Cloud Extract FAQ for information on setting up and using BICC.

Cause

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