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 OCTOBER 17, 2016

Applies to:

Oracle Inventory Management - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

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: 

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

STEPS

1. Go to: Inventory

2. Navigate to: Move Orders > Transact Move Order

3. Query specific Move Order,

4. Click on Transact button, get error.

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms