Oracle Taleo Enterprise Edition: Error with Filter on an 'Is Most Recent' Column: "A comparison is being carried out between non-compatible types TIMESTAMP and DOUBLE PRECISION."
(Doc ID 3015433.1)
Last updated on APRIL 15, 2024
Applies to:
Oracle Taleo Platform Cloud Service - Reporting and Analytics - Version 23C and laterInformation in this document applies to any platform.
Symptoms
Problem Description:
When running an analysis / report with one of the following columns used as a filter, the error below is received:
- Profile Experience Is Most Recent Based On Start Date
- Submission Experience Is Most Recent Based On Start Date
- Profile Education Is Most Recent Based on Graduation Date
- Submission Education Is Most Recent Based on Graduation Date
Error
View Display Error
Odbc driver returned an error (SQLExecDirectW).
Error Details
Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000)
State: HY000. Code: 43275. [nQSError: 43275] Message returned from OBIS. (HY000)
State: HY000. Code: 43119. [nQSError: 43119] Query Failed. (HY000)
State: HY000. Code: 22024. [nQSError: 22024] A comparison is being carried out between non-compatible types TIMESTAMP and DOUBLE PRECISION (HY000)
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 |
| Cause |
| Solution |
| References |