Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Getting error in BICC while running the DOO Line Detail — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Getting error in BICC while running the DOO Line Detail

Accepted answer
15
Views
2
Comments
edited Jun 24, 2020 6:41AM in General Transactional Reporting (OTBI) 2 comments

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.
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!