FA OTBI: Errors While Running The BICCC Extracts FscmTopModelAM.DooTopAM.Header (Doc ID 2436110.1)

Last updated on JUNE 28, 2022

Applies to:

Symptoms

Issue with HEADERBIEFFEFFBIFLATTENED & FULFILLLINEBIEFFEFFBIFLATTENED when attempting to run Cloud Extract from biacm OR issue also appear while running the OTBI report


OTBI: Reports using some of the attributes are failing with ADFservice error. Error occurs while calling remote service ADFService11G. Details: Runtime error for service -- ADFService11G - JBO-25096: Accessor FulfillLineDetailBIEffEFFBIFlattened was not correctly resolved in view def FulfillLineDetailPVO. Locate the resolution error and address the issue. (HY000

the following error occurs.

ERROR
-----------------------
Error 1
-------
Error message for the VO FscmTopModelAM.DooTopAM.Header ---

oracle.obiacm.dataExtract.DataExtractException: Error executing query at oracle.obiacm.queryprocessing.BIServerQuery.runQuery(BIServerQuery.java:1240) at oracle.obiacm.queryprocessing.BIServerQuery.runQuery(BIServerQuery.java:1197) at oracle.obiacm.queryprocessing.BIServerQuery.runDataExtractQuery(BIServerQuery.java:395) at oracle.obiacm.dataExtract.BIVOExtractTask.doNormalExtract(BIVOExtractTask.java:128) at oracle.obiacm.dataExtract.BIVOExtractTask.doDataExtract(BIVOExtractTask.java:102) at oracle.obiacm.dataExtract.BIVOExtractTask.doRun(BIVOExtractTask.java:86) 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: java.io.IOException: execute query failed[nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 77031] Error occurs while calling remote service ADFService11G. Details: Runtime error for service -- ADFService11G - No such view attribute name AddressId in oracle.apps.scm.doo.publicView.analytics.HeaderPVO at oracle.bi.jdbc.AnaJdbcStatementImpl.executeQuery(AnaJdbcStatementImpl.java:387) at oracle.obiacm.queryprocessing.BIServerQuery.runQuery(BIServerQuery.java:1223) ... 9 more

Error 2
--------
This comes while edit of the VO

  JBO-29000: Unexpected exception caught: oracle.apps.bi.configmngr.common.SCMJboError, msg=[BIACM0126] Error fetching metadata from RPD. The data store maybe missing in the RPD.

Cause

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