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.
When reporting on "Requisition Department"."Req. Department Name" in Recruiting (Legacy) Subject Area, the field will return the following ODBC error:
View Display Error
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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!