My Oracle Support Banner

Allocating - The Material Sourcing Process Failed To Create Picking Suggestions For Line Number (Doc ID 1082287.1)

Last updated on AUGUST 21, 2018

Applies to:

Oracle Inventory Management - Version 12.0.6 and later
Information in this document applies to any platform.
INV_DETAILING_FAILED - Error: The material sourcing process failed to create picking suggestions for line &LINE_NUM of move order number &MO_NUMBER
INVPCKRL.fmb - Picking Rule Form
WSHPSGL - Pick Selection List Generation

Symptoms

After creating a new Inventory picking rules, while trying to allocate a Pick wave move order error occurs. 

Error
The material sourcing Process failed to create picking suggestions for line number *** of Move order number.

Steps
1. Go to Transact Move Orders form
2. Query the Pick wave move order.
3. In Transact Move Orders (main) window, press  allocate Button, it shows the error message.

Log file
A snippet from the log file follows.
WSHPSGL - Pick Selection List Generation
...
[05-NOV-09 11:30:27] INV_QUANTITY_TREE_PVT: in add_qty, node_index=536870913, qtyType=5, g_qoh=1, node_level=1...
[05-NOV-09 11:30:27] INV_QUANTITY_TREE_PVT: in add_quantities... EXP_ERROR sql=User-Defined Exception
[05-NOV-09 11:30:27] wms.plsql.WMS_Rule_PVT.validate_and_insert.err_update_qty: Error in inv_quantity_tree_pvt.update_quantities
[05-NOV-09 11:30:27] wms.plsql.WMS_Rule_PVT.validate_and_insert.error: Error - INVFND_API.G_MISS_CHARINV-WRONG_LEVELFND_API.G_MISS_CHAR
[05-NOV-09 11:30:27] wms.plsql.WMS_Rule_PVT.Apply.err_validate_insert: Error in validate_and_insert
[05-NOV-09 11:30:27] wms.plsql.WMS_Rule_PVT.rollback_capacity_update.start: Start rollback_capacity_update
[05-NOV-09 11:30:27] wms.plsql.WMS_Rule_PVT.rollback_capacity_update.end: End rollback_capacity_update
[05-NOV-09 11:30:27] wms.plsql.WMS_Rule_PVT.Apply.error: Expected error - INVFND_API.G_MISS_CHARINV-WRONG_LEVELFND_API.G_MISS_CHAR
[05-NOV-09 11:30:27] wms.plsql.WMS_Strategy_PVT.Apply.error: Error in Apply - INVFND_API.G_MISS_CHARINV-WRONG_LEVELFND_API.G_MISS_CHAR

Changes

Applied Patch 7502663.

Cause

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
Symptoms
Changes
Cause
 Investigation
 Cause #1:
 Cause #2:
 Cause #3:
Solution
  For Cause #1:
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.