My Oracle Support Banner

Fusion BICC Extract Fail For PVO CrmAnalyticsAM.FinFunBusinessUnitsAM.BusinessUnitUsagePVO (Doc ID 2889562.1)

Last updated on AUGUST 17, 2022

Applies to:

Oracle Fusion Financials Common Module Cloud Service - Version and later
Information in this document applies to any platform.


When attempting to run BICC Extract on CrmAnalyticsAM.FinFunBusinessUnitsAM.BusinessUnitUsagePVO ,
the following error occurs.

oracle.obiacm.dataExtract.DataExtractException: Error executing query at oracle.obiacm.queryprocessing.BIServerQuery.getVOColumnsFromADFLabel( at oracle.obiacm.dataExtract.BIVOExtractTask.determineExtractColumns( at oracle.obiacm.dataExtract.BIVOExtractTask.doNormalExtract( at oracle.obiacm.dataExtract.BIVOExtractTask.doDataExtract( at oracle.obiacm.dataExtract.BIVOExtractTask.doRun( at at$ at weblogic.invocation.ComponentInvocationContextManager._runAs( at weblogic.invocation.ComponentInvocationContextManager.runAs( at at at at at Caused by: java.sql.SQLException: prepare query failed[nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 43093] An error occurred while processing the EXECUTE PHYSICAL statement. [nQSError: 77031] Error occurs while calling remote service ADFService11G. Details: Runtime error for service -- ADFService11G - JBO-26104: An error occurred while converting pers def cust for def, ADFSO BaseLabel newCertifiedLabel_06-Aug-2022 12:24:26:689 +0000, ADFSO ActualLabel newCertifiedLabel_06-Aug-2022 12:24:26:689 +0000 RootCause (java.lang.ArrayIndexOutOfBoundsException): 264 at at oracle.obiacm.queryprocessing.BIServerQuery.getUILabelsForVOColumns( at oracle.obiacm.queryprocessing.BIServerQuery.getVOColumnsFromADFLabel( ... 13 more

The issue can be reproduced at will with the following steps:
1. Run BICC Extract for CrmAnalyticsAM.FinFunBusinessUnitsAM.BusinessUnitUsagePVO


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.