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 .
Oracle Forum - The Knowledge Center for Oracle Professionals - Looking Beyond the Possibilities › Oracle Applications › Oracle E-Business Suite (EBS) › Purchasing, Inventory & Order Management v
Order Lines stucked in Booked status

Thread Rating:
  • 66 Vote(s) - 3 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Order Lines stucked in Booked status
10-06-2010, 04:19 PM,
#1
admin Offline
Administrator
*******
 		Posts: 216
Joined: Oct 2010
Reputation: 4
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!
Find
Reply
10-07-2010, 03:57 AM,
#2
Kashif Manzoor Offline
Super Moderator
******
 		Posts: 185
Joined: Oct 2010
Reputation: 0
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.
Website Find
Reply
10-11-2010, 04:54 PM,
#3
rabbi Offline
Junior Member
**
 		Posts: 1
Joined: Oct 2010
Reputation: 0
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: 136)
Find
Reply
09-15-2013, 11:05 PM, (This post was last modified: 09-15-2013, 11:09 PM by ksbtt_53@yahoo.com.)
#4
ksbtt_53@yahoo.com Offline
Junior Member
**
 		Posts: 1
Joined: Oct 2012
Reputation: 0
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
Find
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  R12 Order Management BR100 larodrigmx 0 2,678 06-11-2020, 08:54 AM
Last Post: larodrigmx
  How to default subinventory in Sales Order line Anumeha Manish 3 9,209 10-27-2016, 12:18 AM
Last Post: gonzaloprax
  Purchase Order Error Codes siddesh.99 0 3,422 12-08-2015, 04:46 PM
Last Post: siddesh.99
  COGS transactions created in Sales Order Gopal Ayog 1 3,664 02-02-2015, 09:13 PM
Last Post: Balin Chakra
  How to get PO Quantity in order management Ali Rizwan 5 6,056 01-19-2015, 08:23 PM
Last Post: Divya Omkar
  Order Import Interface error table Saleem Akhtar 1 17,162 12-14-2014, 05:51 PM
Last Post: Kashif Manzoor
  PO ending with Pre-approved status Rubab Ali 1 8,765 11-09-2014, 10:03 PM
Last Post: Kashif Manzoor
  which is API to update the work order status in eam module admin 1 11,912 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 4,143 02-11-2014, 10:26 PM
Last Post: shirfan
  split Sales Order line as per partial availability of stocks Justen Kegan 1 5,852 12-08-2013, 11:59 PM
Last Post: Kashif Manzoor



Users browsing this thread: 1 Guest(s)