My Oracle Support Banner

BICCC: Extract On VO Errors With ORA-00904: "<column>": invalid identifier (Doc ID 2727344.1)

Last updated on NOVEMBER 18, 2020

Applies to:

Oracle Fusion Global Human Resources Cloud Service - Version 11.13.20.07.0 and later
Information in this document applies to any platform.

Symptoms

Extract of a VO in BICC errors with ORA-00904: "{column}": invalid identifier

[2020-10-05T17:32:55.831+00:00] [bi_server1] [WARNING] [] [oracle.obiacm.dataExtract.BIVOExtractTask] [tid: 38] [ecid: 0000XXX7xxXXxX95Rxx2xx1XXXX000f5e,1:151326] [APP: oracle.biacm#11.1.1] [ESS_JobMetadataID: JobDefinition://oracle.apps.ess.biccc/BICloudConnectorJobDefinition] [ESS_RequestID: 123456] [ESS_Module: Processor] {VO NAME} - DataExtractQuery: Attempt=0, QueryExecTime=6530ms, QueryExecTimeLimit=60000ms, Failed Query: set variable DISABLE_RIGHTTRIM_FOR_VARCHAR=1,OBIS_DBFEATURES_DEFAULT_BULK_FETCH_ROW_COUNT=1000,OBIS_DBFEATURES_MAX_BULK_FETCH_BUFFER_SIZE=3145728;select {column list} from EXTERNAL('ADF','"oracle.apps.fscm.model.analytics.applicationModule.FscmTopModelAM_FscmTopModelAMLocal"."Connection Pool"').'{VO NAME}' as t[[
java.sql.SQLException: java.io.IOException: execute query failed[nQSError: 43113] Message returned from OBIS.
[nQSError: 43119] Query Failed:
[nQSError: 17001] Oracle Error code: 904, message: ORA-00904: "{column}": invalid identifier
 at OCI call OCIStmtExecute.
[nQSError: 17010] SQL statement preparation failed.
...


 

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution

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