HCM Group based on value set not pulling in members

Hello Community,

we're trying to create an HCM Group using a Value Set.

The Group is not pulling in any members though. The Where and From clauses seem to be correct, as the query itself gives back results in the backend.

The details of the value set:

Validation Type: Table

Value data type: Number

From Clause: per_all_assignments_f paa, per_jobs pj, hr_organization_units hou

Value column name: ASSIGNMENT_ID

Where Clause: paa.job_id = pj.job_id

AND paa.business_unit_id = hou.organization_id

AND TRUNC(SYSDATE) BETWEEN paa.effective_start_date AND paa.effective_end_date