Pick Release Process Is Failing and the Sales Order is Getting Backordered INV_QUANTITY_TREE_PVT: in add_quantities... EXP_ERROR sql=User-Defined Exception

(Doc ID 1927275.1)

Last updated on JULY 17, 2017

Applies to:

Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.
Upgraded from 11i to Release 12.1.x / 12.2.x

Symptoms

Pick Selection List Generation program is completing with warning & pick release process is failing and the sales order is getting back order.

[21-AUG-14 13:37:45] INV_QUANTITY_TREE_PVT: UPDATE_QUANTITIES Entered
[21-AUG-14 13:37:45] INV_QUANTITY_TREE_PVT: ADD_QUANTITIES Entered
[21-AUG-14 13:37:45] INV_QUANTITY_TREE_PVT: for node: rev= lot= sub= loc= lpn=..with qty type=5 qty=10 action= xfrsub= xfrloc=
[21-AUG-14 13:37:45] INV_QUANTITY_TREE_PVT: in add_quantities... EXP_ERROR sql=User-Defined Exception
[21-AUG-14 13:37:45] wms.plsql.WMS_Rule_PVT.validate_and_insert.err_update_qty: Error in inv_quantity_tree_pvt.update_quantities
[21-AUG-14 13:37:45] wms.plsql.WMS_Rule_PVT.validate_and_insert.error: Error - INVFND_API.G_MISS_CHARINV-WRONG_LEVELFND_API.G_MISS_CHAR
[21-AUG-14 13:37:45] wms.plsql.WMS_Rule_PVT.Apply.err_validate_insert: Error in validate_and_insert
[21-AUG-14 13:37:45] wms.plsql.WMS_Rule_PVT.rollback_capacity_update.start: Start rollback_capacity_update
[21-AUG-14 13:37:45] wms.plsql.WMS_Rule_PVT.rollback_capacity_update.end: End rollback_capacity_update
[21-AUG-14 13:37:45] wms.plsql.WMS_Rule_PVT.Apply.error: Expected error - INVFND_API.G_MISS_CHARINV-WRONG_LEVELFND_API.G_MISS_CHAR
[21-AUG-14 13:37:45] wms.plsql.WMS_Strategy_PVT.Apply.error: Error in Apply - INVFND_API.G_MISS_CHARINV-WRONG_LEVELFND_API.G_MISS_CHAR

Note: You verified there is sufficient on hand in the staging subinventory and no pending reservations not transaction in the MTI/MMTT that could be affecting your item availability - you can do so by running and reviewing the Item diagnostics for the item you are testing  "Oracle Item Data Collection" Diagnostic (See <Note 463602.1>).

Changes

 Upgraded instance from 11.5.10.2 to Release 12.1.x to 12.2.x

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