Module: OMFulfillmentSeverity: BLOCKER
Sales Order Line Stuck in AWAITING_SHIPPING Status Without Pick Wave
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
AWAITING_SHIPPINGorder line stuck in awaiting shippingpick wave not generatingshipping workflow halted
Root Cause Analysis
Order line {lineNum} has shipping_interfaced_flag = "N" or hold preventing delivery generation.
Diagnostic SQL Queries (Read-Only)
CHECK_ORDER_LINE_STATUSInspect line flow status and shipping eligibility
SELECT l.line_id, l.header_id, l.line_number, l.flow_status_code,
l.schedule_ship_date, l.shipping_interfaced_flag
FROM oe_order_lines_all l
WHERE l.line_id = :lineIdRemediation Mode: MANUAL_UI
Verification Query
SELECT flow_status_code FROM oe_order_lines_all WHERE line_id = :lineIdExecute 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.