Oracle Fusion HCM Analytics

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Issue with join Dataset and talent acquisition subject area

Accepted answer
11
Views
1
Comments

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.

Best Answer