My Oracle Support Banner

BICCC: Extract On VO Errors With ORA-00942: table or view does not exist (Doc ID 2727242.1)

Last updated on DECEMBER 24, 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-00942: table or view does not exist

[2020-10-05T16:20:52.902+00:00] [bi_server1] [WARNING] [] [oracle.obiacm.dataExtract.BIVOExtractTask] [tid: 38] [ecid: x123xxx456] [APP: oracle.biacm#11.1.1] [ESS_JobMetadataID: JobDefinition://oracle.apps.ess.biccc/BICloudConnectorJobDefinition] [ESS_RequestID: 123456] [ESS_Module: Processor] FscmTopModelAM.GRCTOPBIAM.ProcessPVO - DataExtractQuery: Attempt=0, QueryExecTime=7030ms, 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 t.CreationDateDerived,t.FRCScSecurityPEOAccessorId,t.FRCScSecurityPEOIsApprover,t.FRCScSecurityPEOIsAssessor,t.FRCScSecurityPEOIsEditor,t.FRCScSecurityPEOIsIssueOwner,...,t.SecurityGroupPEOName,t.SecurityGroupPEORoleType from EXTERNAL('ADF','"oracle.apps.fscm.model.analytics.applicationModule.FscmTopModelAM_FscmTopModelAMLocal"."Connection Pool"').'FscmTopModelAM.GRCTOPBIAM.ProcessPVO' 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: 942, message: ORA-00942: table or view does not exist
 at OCI call OCIStmtExecute.
[nQSError: 17010] SQL statement preparation failed.
    at oracle.bi.jdbc.AnaJdbcStatementImpl.executeQuery(AnaJdbcStatementImpl.java:387)
    at oracle.obiacm.queryprocessing.BIServerQuery.runQuery(BIServerQuery.java:1559)
...

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.