My Oracle Support Banner

Error: "No physical join relationships exist between any of the following tables: left..." (Doc ID 2415721.1)

Last updated on JULY 18, 2018

Applies to:

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

Symptoms

When reporting on "Requisition Department"."Req. Department Name" in Recruiting (Legacy) Subject Area, the field will return the following ODBC error:

 

Error

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

Error Details
Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P

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: 14046. [nQSError: 14046] No physical join relationships exist between any of the following tables: left = [ UNV_JOBINFORMATIONDESCRIPTION T2054] and right = [ UNV_DEPARTMENT AS DEPARTMENT_REQ LeftOuterJoin On DEPARTMENT_REQ.DEPARTMENTNO = DEPARTMENTDESC_REQ.DEPARTMENTNO UNV_DEPARTMENTDESCRIPTION AS DEPARTMENTDESC_REQ]. (HY000)

SQL Issued: SELECT 0 s_0, "Recruiting (Legacy)"."Requisition Department"."Req. Department Name" s_1 FROM "Recruiting (Legacy)" FETCH FIRST 5000001 ROWS ONLY

 

 

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!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.