Book Order error in Order Management – Order is not eligible for booking.
Order is not eligible for booking. Check workflow status for this order.
When Trying to book the Order we are getting the below error.
In the above screenshot we can check the Error by this Navigation
Order Management Responsibility > Order Organizer > Query Order (Not opening the Order Number)> Action > Book Order
While checking the RA_INTERFACE_LINES_ALL table where the order information is not found.
On Searching I just came to some references that to change the Deferred that is to run Workflow Background Process however this did not work.
On Further Research I came across this document and this worked for me
Where option 2 Worked for me that is
Below are the screenshots
After Submission the Order will be completed.
Now as there are many Orders that are in deferred state so I have to Run retry process in BULK so below is the code
/* Formatted on 9/27/2016 10:11:17 AM (QP5 v5.185.11230.41888) */
FROM wf_item_activity_statuses ias, wf_process_activities pa
WHERE ias.item_type = ‘OEOH’
AND ias.process_activity = pa.instance_id
AND ias.ACTIVITY_STATUS = ‘DEFERRED’
AND pa.INSTANCE_LABEL = ‘WAIT-1’;
FOR x IN c_err_itemkey
x.process_name || ‘:’ || x.instance_label,
After Running this try to run Workflow Background process and then after some time run AutoInvoiceImport Program.