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

Last updated on AUGUST 17, 2022

Applies to:

Symptoms

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

ERROR
-----------------------
oracle.obiacm.dataExtract.DataExtractException: Error executing query at oracle.obiacm.queryprocessing.BIServerQuery.getVOColumnsFromADFLabel(BIServerQuery.java:757) at oracle.obiacm.dataExtract.BIVOExtractTask.determineExtractColumns(BIVOExtractTask.java:164) at oracle.obiacm.dataExtract.BIVOExtractTask.doNormalExtract(BIVOExtractTask.java:250) at oracle.obiacm.dataExtract.BIVOExtractTask.doDataExtract(BIVOExtractTask.java:135) at oracle.obiacm.dataExtract.BIVOExtractTask.doRun(BIVOExtractTask.java:119) at oracle.obiacm.dataExtract.AbstractCancellableTask.run(AbstractCancellableTask.java:37) at weblogic.work.j2ee.J2EEWorkManager$WorkWithListener.run(J2EEWorkManager.java:209) at weblogic.invocation.ComponentInvocationContextManager._runAs(ComponentInvocationContextManager.java:352) at weblogic.invocation.ComponentInvocationContextManager.runAs(ComponentInvocationContextManager.java:337) at weblogic.work.LivePartitionUtility.doRunWorkUnderContext(LivePartitionUtility.java:60) at weblogic.work.PartitionUtility.runWorkUnderContext(PartitionUtility.java:41) at weblogic.work.SelfTuningWorkManagerImpl.runWorkUnderContext(SelfTuningWorkManagerImpl.java:655) at weblogic.work.ExecuteThread.execute(ExecuteThread.java:420) at weblogic.work.ExecuteThread.run(ExecuteThread.java:360) Caused by: java.sql.SQLException: java.io.IOException: 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 oracle.apps.financials.legalEntity.legalEntities.publicView.analytics.LegalEntityPVO, 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 oracle.bi.jdbc.AnaJdbcStatementImpl.executeQuery(AnaJdbcStatementImpl.java:387) at oracle.obiacm.queryprocessing.BIServerQuery.getUILabelsForVOColumns(BIServerQuery.java:961) at oracle.obiacm.queryprocessing.BIServerQuery.getVOColumnsFromADFLabel(BIServerQuery.java:741) ... 13 more


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

Cause

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