Cannot Pick Release Items, Completes with Warning and the Item is Backordered. (Doc ID 1240404.1)

Last updated on JULY 18, 2017

Applies to:

Oracle Inventory Management - Version 12.0.0 and later
Information in this document applies to any platform.
WSHPSGL Pick Selection List Generation INVPCKRL.fmb


Symptoms

In a non WMS enabled organization, upgraded from R11.5.10.2 to R12.1.2. Any attempt to pick release ends with the item being back ordered even though there is plenty of inventory and the sales order has a valid reservation.

In Oracle Order Management
1) Navigate to Shipping
2) Release Sales Order
3) Release sales order

Errors in Pick Selection List Generation with Inventory debug on:

INV_QUANTITY_TREE_PVT:
[22-SEP-10 07:51:42] wms.plsql.WMS_Rule_PVT.validate_and_insert.att_qty: Available quantity = 3588
[22-SEP-10 07:51:42] wms.plsql.WMS_Rule_PVT.validate_and_insert.satt_qty: Secondary Available quantity =
[22-SEP-10 07:51:42] wms.plsql.WMS_Rule_PVT.validate_and_insert.grade_code: grade_code =
[22-SEP-10 07:51:42] wms.plsql.WMS_Rule_PVT.validate_and_insert.tree_qty: ATT < possible quantity. New possible qty:
[22-SEP-10 07:51:42] wms.plsql.WMS_Rule_PVT.validate_and_insert.rem_qty: remaining quantity : 0
[22-SEP-10 07:51:42] wms.plsql.WMS_Rule_PVT.validate_and_insert.rem_qty: remaining sec qty :
[22-SEP-10 07:51:42] wms.plsql.WMS_Rule_PVT.validate_and_insert.update_tree: Updating qty tree
[22-SEP-10 07:51:42] INV_QUANTITY_TREE_PVT: UPDATE_QUANTITIES Entered
[22-SEP-10 07:51:42] INV_QUANTITY_TREE_PVT: ADD_QUANTITIES Entered
[22-SEP-10 07:51:42] INV_QUANTITY_TREE_PVT: for node: rev= lot= sub= loc= lpn=..with qty type=5 qty=10 action= xfrsub= xfrloc=
[22-SEP-10 07:51:42] INV_QUANTITY_TREE_PVT: in add_quantities... EXP_ERROR sql=User-Defined Exception
[22-SEP-10 07:51:42] wms.plsql.WMS_Rule_PVT.validate_and_insert.err_update_qty: Error in inv_quantity_tree_pvt.update_quantities
[22-SEP-10 07:51:42] wms.plsql.WMS_Rule_PVT.validate_and_insert.error: Error - INVFND_API.G_MISS_CHARINV-WRONG_LEVELFND_API.G_MISS_CHAR
[22-SEP-10 07:51:42] wms.plsql.WMS_Rule_PVT.Apply.err_validate_insert: Error in validate_and_insert
[22-SEP-10 07:51:42] wms.plsql.WMS_Rule_PVT.rollback_capacity_update.start: Start rollback_capacity_update
[22-SEP-10 07:51:42] wms.plsql.WMS_Rule_PVT.rollback_capacity_update.end: End rollback_capacity_update
wms.plsql.WMS_Rule_PVT.Apply.l_rule_id: 10060


Changes

Upgraded from 11.5.10.2 to R12.1.2

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