INVTOTRX Receive Error 'The material sourcing Process failed to create picking suggestions ...' On Allocating Sales Order Move Order Lines

Last updated on JULY 13, 2017

Applies to:

Symptoms

In Release 12. When attempting to manually allocate sales order move order lines in Transact Move Orders form (INVTOTRX), the following error #1 occurs and the line gets backordered.

When launching the pick release for the same with Auto Allocate=Yes, the following error #2 occurs.

Issue reported for lot controlled and lot divisible items with enough available quantity.

ERROR #1
In Transact Move Orders form:
"Error: The material sourcing Process failed to create picking suggestions for line <line
number> of Move order number <move order number>."

ERROR #2
In Inventory debug file for pick release with Auto Allocate=Yes:
[
[...] wms.plsql.WMS_Rule_PVT.validate_and_insert.update_tree: Updating qty tree
[...] INV_QUANTITY_TREE_PVT: UPDATE_QUANTITIES Entered
[...] INV_QUANTITY_TREE_PVT: ADD_QUANTITIES Entered
[...] INV_QUANTITY_TREE_PVT: in add_quantities... EXP_ERROR sql=User-Defined Exception
[...] wms.plsql.WMS_Rule_PVT.validate_and_insert.err_update_qty: Error in
inv_quantity_tree_pvt.update_quantities
[...] wms.plsql.WMS_Rule_PVT.validate_and_insert.error: Error -
INVFND_API.G_MISS_CHARINV-WRONG_LEVELFND_API.G_MISS_CHAR
]

STEPS
The issue can be reproduced at will with the following steps:
1. Go to Transact Move Orders form
2. Query the sales order
3. In Transact Move Orders (main) window, press button Allocate
4. See the reported error

Cause