My Oracle Support Banner

Fusion - BICCC Extract Failing - Error 500--Internal Server Error - 10.5.1 500 Internal Server Error (Doc ID 2596653.1)

Last updated on OCTOBER 24, 2019

Applies to:

Oracle Fusion Financials Common Module Cloud Service - Version and later
Information in this document applies to any platform.


BICCC incremental extracts scheduled to run on daily basis have failed with below error

FscmTopModelAM.CatalogAM.CategoryAssignmentP1 with [IMPL SPT]

oracle.obiacm.dataExtract.DataExtractException: Error executing query at oracle.obiacm.queryprocessing.BIServerQuery.runQuery( at oracle.obiacm.queryprocessing.BIServerQuery.runQuery( at oracle.obiacm.queryprocessing.BIServerQuery.runDataExtractQuery( at oracle.obiacm.dataExtract.BIVOExtractTask.doNormalExtract( at oracle.obiacm.dataExtract.BIVOExtractTask.doDataExtract( at oracle.obiacm.dataExtract.BIVOExtractTask.doRun( at at$ at at Caused by: java.sql.SQLException: execute query failed[nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed:

Detailed error as per nqquery log:
Error 500--Internal Server Error
10.5.1 500 Internal Server Error
The server encountered an unexpected condition which prevented it from fulfilling the request.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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