An Oracle Fusion HCM line-manager query must identify the employee's relevant assignment. A worker with more than one assignment can have different manager relationships. Selecting a manager directly from an unfiltered list can explain why a report disagrees with HR.
Start with the employee lookup and resolve the worker's resource key. Retrieve its work relationships, then inspect the assignments for the date in question. Keep the work-relationship identifier with the selected assignment so later reads remain attached to the same employment context.
The manager collection is under the selected assignment. Its documented route has the form GET /hcmRestApi/resources/11.13.18.05/workers/{workerKey}/child/workRelationships/{periodOfServiceId}/child/assignments/{assignmentKey}/child/managers. Each placeholder must come from the corresponding prior Oracle response. The displayed assignment number is not necessarily the assignment resource key.
Inspect the returned manager type and manager identifiers using Oracle's assignment-manager reference. A line manager and another supervisory relationship answer different questions. Resolve the manager's person information after selecting the relationship that matches the request.
Check effective dates against the selected assignment date. A future manager change can exist alongside the current relationship. Oracle's date-effective worker example explains how the parent employment view changes with the requested date. Use the documented date behavior of each child resource.
This CLHAPI line-manager SQL uses a synthetic employee and a fixed reporting date. It retains the effective-date joins and exposes assignment identifiers so concurrent manager relationships remain distinguishable. Replace the employee number and every date together.
SELECT emp.person_number AS employee_person_number,
pnf.display_name AS employee_name,
sup.assignment_id,
mgr.person_number AS manager_person_number,
mnf.display_name AS manager_name,
sup.manager_assignment_id,
sup.manager_type,
sup.effective_start_date,
sup.effective_end_date
FROM per_assignment_supervisors_f sup
JOIN per_all_people_f emp
ON emp.person_id = sup.person_id
AND DATE '2026-10-31' BETWEEN emp.effective_start_date
AND emp.effective_end_date
JOIN per_person_names_f pnf
ON pnf.person_id = emp.person_id
AND DATE '2026-10-31' BETWEEN pnf.effective_start_date
AND pnf.effective_end_date
AND pnf.name_type = 'GLOBAL'
JOIN per_all_people_f mgr
ON mgr.person_id = sup.manager_id
AND DATE '2026-10-31' BETWEEN mgr.effective_start_date
AND mgr.effective_end_date
JOIN per_person_names_f mnf
ON mnf.person_id = mgr.person_id
AND DATE '2026-10-31' BETWEEN mnf.effective_start_date
AND mnf.effective_end_date
AND mnf.name_type = 'GLOBAL'
WHERE emp.person_number = '100123'
AND DATE '2026-10-31' BETWEEN sup.effective_start_date
AND sup.effective_end_date
AND UPPER(sup.manager_type) = 'LINE_MANAGER'
ORDER BY emp.person_number, sup.assignment_id;Match ASSIGNMENT_ID to the employee's relevant assignment before choosing a manager. Oracle's workforce view definition documents the assignment-to-supervisor relationship. An inner join can omit a relationship whose matching dated name or person row is unavailable.
If the collection is empty, verify the assignment and its visibility before diagnosing missing setup. Confirm that the assignment belongs to the expected work relationship. An inactive or secondary assignment may be a valid record but the wrong one for the business question.
Fusion Toolkit's documented manager-list operation accepts the resolved worker, work-relationship and assignment keys. The installed AI Administrator catalog exposes its required inputs. Preserve the selected keys with the result when investigating an approval issue. The expense approval guide explains why an existing task's assignee also needs a separate read.
The route and workflow were reviewed on 8 November 2026. Compare one employee's returned manager with the dated assignment in Oracle before using the result in an integration.
You can also use an LLM with the Fusion Toolkit AI Administrator skill and ask, "Who is the line manager for employee 100123 on 31 October 2026?" It can resolve the supported Oracle records without requiring you to write the query. Specify the assignment as well if the employee has more than one.