Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Getting error in BICC while running the DOO Line Detail

Received Response
216
Views
2
Comments
vijayakrishna
vijayakrishna Rank 1 - Community Starter
in Oracle Transactional Business Intelligence

Summary

BICC job is failing while running the DOO Line Detail

Content

BICC job is failing while running the Line Detail. Attached is the log file. Please help

Table name: FscmTopModelAM.DooTopAM.FulfillLineDetail

ERROR:[BIACM0104] Cause: BI Data Extract Job failure due to : oracle.obiacm.dataExtract.DataExtractException: Error executing query.

Log error:

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-25002: Definition oracle.apps.publicFlex.scm.doo.fulfillLineDetailCategories.analytics.view.FulfillLineDtlBIEffEFFBIFlattenedVO of type View Definition is not found.
at oracle.bi.jdbc.AnaJdbcStatementImpl.executeQuery(AnaJdbcStatementImpl.java:387)
at oracle.obiacm.queryprocessing.BIServerQuery.runQuery(BIServerQuery.java:1518)
... 10 more
 

 

Tagged:

Answers

  • Rajasekhar Bandaru-Oracle
    Rajasekhar Bandaru-Oracle Rank 6 - Analytics Lead

    Hi

    Please review the below documentsand follow the steps and then test the results.

    FA OTBI: - ADFService11G - JBO-25096: Accessor ItemEFFBIFlattenedVO Was Not Correctly Resolved; def InventoryItemRefPVO (Doc ID 2183893.1)

  • vijayakrishna
    vijayakrishna Rank 1 - Community Starter

    Thanks, IT worked after Deploying the DFF