Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 19 Oracle Analytics Lounge
- 222 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.8K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 83 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
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

vijayakrishna
Rank 1 - Community Starter
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:
0
Answers
-
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)
0 -
Thanks, IT worked after Deploying the DFF
0