Issue with join Dataset and talent acquisition subject area

User_ESDSR

Hi Team,

New Dataset from HCM - Talent Acquisition

SELECT
0 s_0,
"HCM - Talent Acquisition"."Job Requisition - Basic Information"."Requisition Number" s_1,
max("HCM - Talent Acquisition"."Job Offer - Basic Information"."Move to HR Date" by "HCM - Talent Acquisition"."Job Requisition - Basic Information"."Requisition Number") s_2
FROM "HCM - Talent Acquisition"

Joining with HCM - Talent Acquisition SUBJECT AREA

join condition:

Requisition Number=Requisition Number

Issue:

Error during query processing (SQLExecDirectW).
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 [ecid:9f85a122-9ab4-4afc-b0dc-a7d79c07d9e1-002351aa,0:1:1:6 ts:2025-03-10T11:09:14.887+00:00].
(HY000)
State: HY000. Code: 43119. [nQSError: 43119] Query Failed:
(HY000)
State: HY000. Code: 22073. [nQSError: 22073] Internal Error: (Generation of physical plan for dimension query failed with (HY000)
State: HY000. Code: 14046. [nQSError: 14046] No physical join relationships exist between any of the following tables: left = [
(1)
RqJoinNode <<527451571>> [(InNode:<<527451617>>) (OutNode:<<527451571>>) , (InNode:<<527451631>>) (OutNode:<<527451571>>) , (InNode:<<527451637>>) (OutNode:<<527451571>>) , (InNode:<<527451650>>) (OutNode:<<527451571>>) , (InNode:<<527451663>>) (OutNode:<<527451571>>) , (InNode:<<527451571>>) (OutNode:<<527451643>>) ]
DW_TA_JOB_REQUISITION_D AS Dim_DW_TA_JOB_REQUISITION_D_DimOnly LeftOuterJoin <<527451580>> On SEC_SECURE_BY_OBJ_MEMBER_USER_HCM_RECTYPE_Dim.SEC_OBJ_MEMBER_VAL = Dim_DW_TA_JOB_REQUISITION_D_DimOnly.RECRUITING_TYPE_CODE

Please help on fix the issue on joining to get

max(Move to HR Date) by req number as per my business requirement .

Thanks & Regards,

Yedukondalu.

Mallikarjuna Kuppauru-Oracle

Hi @User_ESDSR

As per Error message its an issue with your Design and Joins.

If you want to compare with external make sure add all necessary joins else it will be error-ed out.

Regards,

Arjun