My Oracle Support Banner

Error: "ORA-00942: table or view does not exist" with "Is Posted Externally" and "Is Posted Internally" Fields (Doc ID 2439970.1)

Last updated on APRIL 30, 2019

Applies to:

Oracle Taleo Platform Cloud Service - Reporting for OBI - Version 17.4 and later
Information in this document applies to any platform.


Error Information:

After receiving the following maintenance:

  • The Cloud Operations team will install the latest OBIEE release (17.6) in the OBI reporting environment.

Running a report or dashboard that includes the following fields from the Recruiting Subject Area:

  • "Requisition Posting"."Is Posted Externally"
  • "Requisition Posting"."Is Posted Internally"

Results in the following error:


View Display Error
Odbc driver returned an error (SQLExecDirectW).

Error Details

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000)

State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000)

State: HY000. Code: 17001. [nQSError: 17001] Oracle Error code: 942, message: ORA-00942: table or view does not exist at OCI call OCIStmtExecute. (HY000)

State: HY000. Code: 17010. [nQSError: 17010] SQL statement preparation failed. (HY000)



Zone has received OBI 17.6 update while their OTAC/TEE Version is at 17.5 or below.


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.