Module: HRHierarchySeverity: HIGH
Self-Service Approval Hierarchy Broken by Circular Supervisor Chain
Enterprise troubleshooting playbook from the OAG ADK 5.0 knowledge base. Designed for Oracle Apps DBAs, techno-functional consultants, and support teams.
Recognized Error Signatures & Log Keywords
circular supervisor chainsupervisor loop hrAME supervisor hierarchy error
Root Cause Analysis
Supervisor hierarchy loops back to person {personId}, halting approval notifications.
Diagnostic SQL Queries (Read-Only)
CHECK_SUPERVISOR_CHAINQuery PER_ALL_ASSIGNMENTS_F for recursive supervisor chains
SELECT person_id, supervisor_id
FROM per_all_assignments_f
WHERE primary_flag = 'Y' AND TRUNC(SYSDATE) BETWEEN effective_start_date AND effective_end_date
AND person_id = :personIdRemediation Mode: MANUAL_UI
Verification Query
SELECT supervisor_id FROM per_all_assignments_f WHERE person_id = :personId AND primary_flag = 'Y'Execute This Fix Safely with OAG AI Consultant
OAG AI Consultant runs directly on your Windows desktop behind your corporate firewall, connecting to your Oracle TNS tier with zero cloud data exposure.