Oracle Forum - The Knowledge Center for Oracle Professionals - Looking Beyond the Possibilities

Full Version: Order Lines stucked in Booked status
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
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!
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.
(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.



(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