Retry / Activities in Error from Sales order lines Workflow

This post help you regrading Oracle Apps Workflow (Order Management).

Sales order Lines Workflow got stuck up so not able to move further activities for BOOKED/Awaiting Shipping/Production Open/Supply eligible for Standard item/ATO item/ATO Model .

In all the above cases check data in wsh_delivery_details table, if the delivery details are in SHIPPED status and ITS has not executed &

1. Shipping Qty
2. Shipped Qty
3. Actual shipment date

not populated in Oracle oe_order_lines_all table , and Workflow for order line is in Error status ,then go to order line in order UI and select line and press right click and select "retry activities in error" from pop up menu, system will show the activities that are in error, if there are multiple activities that are in error.

Select the activity that you want to retry (from LOV) and with that Oracle system will retry the activity and progress the work flow to next Activity (we don't need any y data-fixes script here).

Please not that there is possibility that "retry activity in error" might fails ,because their is valid reason for failure. in such cases there is need to further investigate why it fails.