A transfer order lives a double life: an ORDER (requested → awaiting fulfillment → closed) and its EXECUTION (pick → ship → in-transit → receive → putaway at destination). The order status only moves when execution events interface back, so 'stuck' almost always means an execution event didn't report home.
TO status lags execution because interfaces carry the news.
TO lines and statuses
select header_id, status_code, fulfillment_status from inv_transfer_order_lines where header_id in (select header_id from inv_transfer_order_headers where header_number = '&to_number')
Read-only diagnostic queries. Substitute the bind values for your instance; run in a test environment first.
Checked Order Management and Fulfillment troubleshooting for Oracle Fusion, rewritten in plain words from publicly known practice and reviewed by a working consultant. Checked against the current release, Jul 2026. Navigation and behavior vary by configuration; verify in your own instance and test before acting.