Oracle Forums Community of Oracle Professionals including Fusion/Cloud Application Consultants, ERP Experts, Oracle Apps Functional Consultants, Apps DBAs, DBAs, Cloud DBAs, Technical Consultants, Fusion Middleware Experts, SQL, PL/SQL Developers and Project Managers. Welcome to OraERP.com Social Community, a friendly and active community of Oracle Technology Professionals who believe that technology can ‘make the world a better place’. By joining Oracle ERP Community you will have the ability to Post Topics, Receive our Newsletter, subscribe to threads and access many other special features. Registration is Quick, Simple and Absolutely Free.

Thread Rating:
  • 41 Vote(s) - 2.83 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Order Lines stucked in Booked status
#1
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!
Reply
Thanks given by:
#2
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.
Reply
Thanks given by:
#3
(10-06-2010, 03: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.





Attached Files
.zip   start_ForHeader_missing_flow.zip (Size: 1.17 KB / Downloads: 102)
Reply
Thanks given by:
#4
(10-11-2010, 03:54 PM)rabbi Wrote:
(10-06-2010, 03: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
Reply
Thanks given by:


Possibly Related Threads...
Thread Author Replies Views Last Post
  How to default subinventory in Sales Order line Anumeha Manish 3 2,143 10-26-2016, 11:18 PM
Last Post: gonzaloprax
  Purchase Order Error Codes siddesh.99 0 1,200 12-08-2015, 03:46 PM
Last Post: siddesh.99
  COGS transactions created in Sales Order Gopal Ayog 1 824 02-02-2015, 08:13 PM
Last Post: Balin Chakra
  How to get PO Quantity in order management Ali Rizwan 5 1,513 01-19-2015, 07:23 PM
Last Post: Divya Omkar
  Order Import Interface error table Saleem Akhtar 1 3,995 12-14-2014, 04:51 PM
Last Post: Kashif Manzoor
  PO ending with Pre-approved status Rubab Ali 1 2,246 11-09-2014, 09:03 PM
Last Post: Kashif Manzoor
  which is API to update the work order status in eam module admin 1 5,732 02-20-2014, 10:54 PM
Last Post: shirfan
  Don't allow cancellation of sales order line if the schedule ship date falls within visgyan 1 1,728 02-11-2014, 09:26 PM
Last Post: shirfan
  split Sales Order line as per partial availability of stocks Justen Kegan 1 2,157 12-08-2013, 10:59 PM
Last Post: Kashif Manzoor
  Order entry in an external application luc18mi 1 1,425 11-06-2013, 12:42 AM
Last Post: Arshad Ch



Users browsing this thread: 1 Guest(s)
OTech Talks, Lets Talk OPEN! Get Oracle Tutorials, Tips! Post a Question!