Error: "ORA-00932: inconsistent datatypes: expected.." on Performance Management Text Fields (Doc ID 2180031.1)

Last updated on FEBRUARY 28, 2017

Applies to:

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

Symptoms

 When running an analysis that includes one of the following fields from the Performance Management Subject Area, the below error occurs:

Odbc driver returned an error (SQLExecDirectW).
Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 17001] Error Code: 932, message: ORA-00932: inconsistent data types: expected - got CLOB at OCI call OCIStmtExecute. [nQSError: 17010] SQL statement preparation failed. Please have your System Administrator look at the log for more details on this error.

(HY000) Please have your System Administrator look at the log for more details on this error.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms