PJM Org: Unable To Allocate Sales Orders Error, gets "The material sourcing process failed to create picking suggestions for line 1 of move order number" when trying to pick sales order
(Doc ID 1985572.1)
Last updated on FEBRUARY 03, 2019
Applies to:Oracle Inventory Management - Version 12.2.4 and later
Information in this document applies to any platform.
In PJM (Project Management) enabled org per mtl_parameters (project_reference_enabled =1), end user is unable To Allocate Sales orders and gets below error:
"The material sourcing process failed to create picking suggestions for line 1 of move order number" when trying to pick sales order. On-hand quantities are present.
In addition, INV debug was showing the error below:
[19-FEB-15 15:03:25] wms.plsql.WMS_Rule_PVT.FetchCursor.no_rows_found: No more rows for rule WMS_PICK_NO_ROWS
19-FEB-15 15:03:25] wms.plsql.WMS_Rule_PVT.FetchCursor.end: End FetchCursor
[19-FEB-15 15:03:25] wms.plsql.WMS_Rule_PVT.Apply.no_recs: No more records from cursor
1. Go to: Inventory
2. Navigate to: Move Orders > Transact Move Order
3. Query specific Move Order,
4. Click on Transact button, get error.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document