Error: "Dimensional logical table sources with nested outer joins cannot mix shared fact tables across the outer join" (Doc ID 2264562.1)

Last updated on MAY 15, 2017

Applies to:

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

Symptoms

After upgrading to TEE Version 15B, reports built from the Recruiting Subject Area are now returning the below error:

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

Error Details Error Codes: OPR4ONWY:U9IM8TAC:0I2DL65P

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 14066] Dimensional logical table sources with nested outer joins cannot mix shared fact tables across the outer join. 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.

 

Changes

 Zone was upgraded from TEE Version 15A to 15B.

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