Friday, June 21, 2013

'No Availability Information' - Error While Booking Order From Depot Repair

We often face error while trying to book order from Depot Repair.

We get below sequence of errors :-
 - No Availability Information
- The item specified is invalid or does not exist in the warehouse you specified. Please enter a valid item-warehouse combination.
   (SQL_CODE=60) (SQLERRM=ORA00060: deadlock detection while waiting for resource
   ORA-06510: PL/SQL: unhandled user-defined exception)

Steps to Reproduce : -
- Create a Repair Order (Error might come if the setup of repair type allows automatically enter and book order, if the item falls under error category)
- If automatically enter and book is not checked for repair type then we follow below setup to book the order.
- Goto Logistics Tab -> Select the line you want to book -> Select the radio button 'Book' and click on Process.