# Fix Oracle EBS Order Lines Stuck in Awaiting Shipping > Source: https://netray.co/erp-help/ebs-order-line-stuck-awaiting-shipping-workflow-fix > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: ERP Help ## Short answer An OM order line sits at Awaiting Shipping because its OEOL workflow is waiting for Ship Confirm, or because the workflow is deferred, errored or never started. Check the line's workflow status in the Workflow Status Monitor, confirm Pick Release and Ship Confirm actually ran, make sure the Workflow Background Process for OEOL is running, and retry the errored activity. ## Kind error ## System oracle-ebs ## Erp Oracle E-Business Suite ## Module Order Management / OM Workflow ## Query EBS Order Management order line stuck in Awaiting Shipping workflow ## Alternate Queries - Oracle OM sales order line stuck in awaiting shipping - OEOL workflow stuck order line Order Management R12 - order line not progressing workflow background process EBS - Workflow Background Process OM deferred activities not running ## Applies To Oracle E-Business Suite R12.1 and R12.2 Order Management with Shipping Execution; the same OEOL and OEOH item types exist in 11i ## Steps ### How to diagnose and release the line **Items:** - Open the order in Order Management > Orders, Returns > Sales Orders, and select the line. Note the line status and use Tools > Workflow Status to see the current activity. - If status is Awaiting Shipping, go to Shipping > Transactions and query the order number. Confirm a delivery line exists and its status (Ready to Release, Staged, Shipped). - If no delivery line exists, the line never released to Shipping. Check holds (Actions > View Holds), then run Pick Release or Release Sales Orders for that order. - If the delivery is Staged but not shipped, finish Ship Confirm. After ship confirm, the Interface Trip Stop SRS program and the OM workflow advance the line to Shipped. - If Workflow Status shows an activity in Error, use the Workflow Status Monitor (Administrator Workflow responsibility) to open the item type OM Order Line, review the error message, and choose Retry. - If the activity is Deferred, make sure a Workflow Background Process for item type OM Order Line is scheduled with Process Deferred = Yes and Process Timeout = Yes. - Run the Workflow Background Process once manually with Item Type = OM Order Line and confirm the line status moves. - Re-query the line and confirm its flow status changed in OE_ORDER_LINES_ALL.FLOW_STATUS_CODE. ## Sections ### How the OEOL workflow decides a line is Awaiting Shipping **Body:** Every order line runs a Workflow process from the item type OM Order Line (OEOL). Standard flows such as Order Flow - Generic with Header level invoicing have activities like Schedule - Line, Shipping - Line (Awaiting Shipping), Fulfill and Invoice Interface. A line shows Awaiting Shipping because the workflow is parked on a block activity, waiting for a notification from Shipping Execution that the delivery was ship confirmed. That means the cause is rarely in OM itself. It is one of: the line was never released (backorder, hold, unscheduled), the delivery detail was released but not confirmed, Ship Confirm completed but the post-confirm programs failed, or the workflow engine is not processing deferred activities. Looking at each in order is faster than guessing. **Code:** SELECT l.line_id, l.line_number, l.flow_status_code, l.shipped_quantity, d.delivery_detail_id, d.released_status FROM oe_order_lines_all l LEFT JOIN wsh_delivery_details d ON d.source_line_id = l.line_id AND d.source_code = 'OE' WHERE l.header_id = :header_id; ### Shipping side checks **Body:** WSH_DELIVERY_DETAILS.RELEASED_STATUS tells you where the physical process stands: R is ready to release, B backordered, S released to warehouse, Y staged, C shipped. A line stuck at Awaiting Shipping with released status B has been backordered, usually due to insufficient on-hand or an unreserved item. Fix availability, then run Pick Release again. If released status is C but the OM line still says Awaiting Shipping, the shipping to OM handoff failed. Check the concurrent request log for Interface Trip Stop - SRS and for errors in the Workflow Status Monitor. Often the trip stop interface errored on inventory (see the open interface page on this site), so OM never received the shipped quantity. ### Workflow engine health **Body:** OM relies on deferred workflow activities. If the Workflow Background Process concurrent program is not scheduled, or its parameters exclude OEOL, activities such as Schedule and Fulfill wait forever and nothing looks broken in the Orders form. Check Concurrent > Requests for scheduled Workflow Background Process runs and verify the last run completed normally. Query WF_ITEM_ACTIVITY_STATUSES for ITEM_TYPE = 'OEOL' and ITEM_KEY = the line_id to see the activity status, result and error message. ACTIVITY_STATUS values of ERROR, DEFERRED and NOTIFIED each point to a different fix: retry, run the background engine, or respond to the notification. **Code:** SELECT a.item_key, pa.instance_label, s.activity_status, s.activity_result_code, s.error_name, s.error_message FROM wf_item_activity_statuses s JOIN wf_process_activities pa ON pa.instance_id = s.process_activity JOIN wf_items a ON a.item_type = s.item_type AND a.item_key = s.item_key WHERE s.item_type = 'OEOL' AND s.item_key = TO_CHAR(:line_id) ORDER BY s.begin_date; ### Bulk cases and what not to do **Body:** When hundreds of lines are stuck, the cause is almost always one shared fault: the background engine down, a missing Interface Trip Stop run, or a bad setup change such as a deleted shipping parameter. Fix the shared cause and use the Retry Errored Workflow Activities concurrent program (WFRETRY) for the OEOL item type, rather than retrying lines one at a time. Avoid updating FLOW_STATUS_CODE directly in OE_ORDER_LINES_ALL. It leaves the workflow, shipping and invoicing records out of step, and later steps then fail in new ways. Oracle Support has data fix patches and documented workflow skip procedures for genuine dead-ends; use those and keep a ticket reference. ## Pitfalls - Checking only the OM form and ignoring Shipping Transactions, where the real status lives. - Forgetting that Workflow Background Process needs separate runs for deferred and timed-out activities. - Retrying an activity in Error without reading the error, which loops the same failure. - Editing FLOW_STATUS_CODE in SQL, which breaks invoicing and the audit trail. - Ignoring holds: a credit check or custom hold stops release without any visible error on the line. - Closing inventory periods while ship-confirmed deliveries are still waiting to interface. ## Ai Angle An assistant grounded in EBS through ERPray can take an order number, read OE_ORDER_LINES_ALL, WSH_DELIVERY_DETAILS and WF_ITEM_ACTIVITY_STATUSES in read-only mode and tell the order desk which of the four causes applies, showing the queries it ran. It follows your EBS responsibilities. Retrying workflow activities or releasing holds stays a human action with approval. It does not replace OM expertise for unusual flows. ## Faq ### What does Awaiting Shipping actually mean in OM? **Answer:** The line passed scheduling and is blocked on the Shipping activity in the OEOL workflow, waiting for Shipping Execution to ship confirm the delivery. Until the delivery ships and the result returns to OM, the line stays at that status. ### How do I retry many errored OM workflow activities at once? **Answer:** Run the Retry Errored Workflow Activities program (WFRETRY) from the Workflow Administrator responsibility, with Item Type set to OM Order Line. Fix the shared cause first, or the same activities will error again. For one line, use Workflow Status Monitor and choose Retry on the errored activity. ### Why does the line show Awaiting Shipping when the delivery is shipped? **Answer:** The interface from Shipping to OM did not complete. Check Interface Trip Stop - SRS for errors, check the inventory interface for failed rows, and look for a deferred or errored activity in the workflow. Once the interface succeeds, the line moves to Shipped. ### Should I use SQL to move a line forward? **Answer:** Not as a first choice. Directly changing statuses desynchronises the workflow, shipping and receivables data. Use supported Oracle procedures or Support-provided data fixes, and test on a cloned instance first. ## Search terms order line awaiting shipping EBS, OEOL workflow stuck, Oracle order management line stuck, workflow background process OM, WFRETRY order line, pick release backordered EBS, interface trip stop error, oe_order_lines_all flow_status_code, R12 order management troubleshooting --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json