Since 2010, OraERP is a Oracle Forums, Community of Oracle Professionals including Fusion/Cloud Application Consultants, Enterprise Architects, ERP Cloud, HCM Cloud, CX Cloud and OCI Experts, ERP Experts, Oracle Apps Functional Consultants, Apps DBAs, DBAs, Cloud DBAs, Digital Architect, PaaS Experts, IaaS, OCI Architects, 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 and Simple. Get unlimited access to Oracle Tutorials, Articles, eBooks, Tools and Tips .
Thread Rating:
  • 59 Vote(s) - 3 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Order Lines stucked in Booked status
10-06-2010, 04:19 PM,
#1
Order Lines stucked in Booked status
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:
10-07-2010, 03:57 AM,
#2
RE: Order Lines stucked in Booked status
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:
10-11-2010, 04:54 PM,
#3
RE: Order Lines stucked in Booked status
(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.





Attached Files
.zip   start_ForHeader_missing_flow.zip (Size: 1.17 KB / Downloads: 130)
Reply
Thanks given by:
09-15-2013, 11:05 PM, (This post was last modified: 09-15-2013, 11:09 PM by ksbtt_53@yahoo.com.)
#4
RE: Order Lines stucked in Booked status
(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
Reply
Thanks given by:


Possibly Related Threads…
Thread Author Replies Views Last Post
  R12 Order Management BR100 larodrigmx 0 542 06-11-2020, 08:54 AM
Last Post: larodrigmx
  How to default subinventory in Sales Order line Anumeha Manish 3 5,806 10-27-2016, 12:18 AM
Last Post: gonzaloprax
  Purchase Order Error Codes siddesh.99 0 2,161 12-08-2015, 04:46 PM
Last Post: siddesh.99
  COGS transactions created in Sales Order Gopal Ayog 1 1,982 02-02-2015, 09:13 PM
Last Post: Balin Chakra
  How to get PO Quantity in order management Ali Rizwan 5 3,314 01-19-2015, 08:23 PM
Last Post: Divya Omkar
  Order Import Interface error table Saleem Akhtar 1 14,005 12-14-2014, 05:51 PM
Last Post: Kashif Manzoor
  PO ending with Pre-approved status Rubab Ali 1 7,116 11-09-2014, 10:03 PM
Last Post: Kashif Manzoor
  which is API to update the work order status in eam module admin 1 9,751 02-20-2014, 11:54 PM
Last Post: shirfan
  Don't allow cancellation of sales order line if the schedule ship date falls within visgyan 1 2,526 02-11-2014, 10:26 PM
Last Post: shirfan
  split Sales Order line as per partial availability of stocks Justen Kegan 1 4,201 12-08-2013, 11:59 PM
Last Post: Kashif Manzoor



Users browsing this thread: 1 Guest(s)
Open Tech Talks Get Oracle Tutorials, Tips! Post a Question!