Oracle Forum - The Knowledge Center for Oracle Professionals - Looking Beyond the Possibilities
Order Lines stucked in Booked status - Printable Version

+- Oracle Forum - The Knowledge Center for Oracle Professionals - Looking Beyond the Possibilities (http://www.oraerp.com)
+-- Forum: Oracle Applications (http://www.oraerp.com/forum-39.html)
+--- Forum: Oracle E-Business Suite (EBS) (http://www.oraerp.com/forum-1.html)
+---- Forum: Purchasing, Inventory & Order Management (http://www.oraerp.com/forum-3.html)
+---- Thread: Order Lines stucked in Booked status (/thread-5.html)



Order Lines stucked in Booked status - admin - 10-06-2010

Some standard order lines are stucked in 'Booked' instead of moving to 'Awaiting Shipping' in our environment.

The OM: AutoSchedule profile value is on. And as I know, when an order is booked, it will auto create a record in wsh_delivery_details. But those order lines never create one and need to click 'Progress Order Line' -> 'Schedule Elgible' to manually.

When looking at the Workflow status of these order lines, it never goes to the 'Create Supply Line' stage.

Is there any workaround to reduce manual work? I now create an alert for it.

Thanks in advance!


RE: Order Lines stucked in Booked status - Kashif Manzoor - 10-07-2010

Sometimes it happened because of ATO Flag in ITEM Master. Remove this Flag from both Master Organization as well as from Inventory Organization (The Org which you are using in Sales Order Line).

And also make sure 'Workflow Background Engine' is schedule to run for every 1 or 2 minutes (based on your requirements). Try to create a New Sales Order Line to verify the result.



RE: Order Lines stucked in Booked status - rabbi - 10-11-2010

(10-06-2010, 04:19 PM)admin Wrote: Some standard order lines are stucked in 'Booked' instead of moving to 'Awaiting Shipping' in our environment.

The OM: AutoSchedule profile value is on. And as I know, when an order is booked, it will auto create a record in wsh_delivery_details. But those order lines never create one and need to click 'Progress Order Line' -> 'Schedule Elgible' to manually.

When looking at the Workflow status of these order lines, it never goes to the 'Create Supply Line' stage.

Is there any workaround to reduce manual work? I now create an alert for it.

Thanks in advance!

I also got the same issue in my environment, i have got a script from Oracle, which will move the line to the next status of Awaiting.
The script takes the Header_id as input, the script is attached.






RE: Order Lines stucked in Booked status - ksbtt_53@yahoo.com - 09-15-2013

(10-11-2010, 04:54 PM)rabbi Wrote:
(10-06-2010, 04:19 PM)admin Wrote: Some standard order lines are stucked in 'Booked' instead of moving to 'Awaiting Shipping' in our environment.

The OM: AutoSchedule profile value is on. And as I know, when an order is booked, it will auto create a record in wsh_delivery_details. But those order lines never create one and need to click 'Progress Order Line' -> 'Schedule Elgible' to manually.

When looking at the Workflow status of these order lines, it never goes to the 'Create Supply Line' stage.

Is there any workaround to reduce manual work? I now create an alert for it.

Thanks in advance!

I also got the same issue in my environment, i have got a script from Oracle, which will move the line to the next status of Awaiting.
The script takes the Header_id as input, the script is attached.

Hi,

Please give fake qty and try to cancel this line it will work.

Regards
Khurram