My Oracle Support Banner

Material Allocation Fails Even Though On-Hand Is Available With The Preferred Grade For Lot Given On Sales Order Line (Doc ID 2879680.1)

Last updated on JUNE 29, 2022

Applies to:

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


Material allocation fails even though on-hand is available with the preferred grade for lot given on sales order line

When attempting to allocate the pick wave move order system is throwing the following error. The move order is eventually backordered.


The material sourcing process failed to create picking suggestions for line 1 of move order xxx.

Debug Log Contents

Additionally, following is seen in the debug log.

INV_QUANTITY_TREE_PVT: odab in find_rootinfo Normal End With index=0, NOT FOUND, return=S
INV_QUANTITY_TREE_PVT: in new_tree, grade=4.167
INV_QUANTITY_TREE_PVT: in new_tree org_id =217, item=3994551, tree_index=449906
INV_QUANTITY_TREE_PVT: in new_tree... grade_code=4.167
INV_QUANTITY_TREE_PVT:       Creating node at level 1 with 449906::::::
INV_QUANTITY_TREE_PVT: In check_is_reservable. node_level=1, subinv=, loct=, lot=
INV_QUANTITY_TREE_PVT: ... normal end of new_tree_node
INV_QUANTITY_TREE_PVT: In new_tree l_negative_inv_receipt_code: 2 l_default_org_status_id:
INV_QUANTITY_TREE_PVT: in new_tree org_id =217
INV_QUANTITY_TREE_PVT:  l_tree_id=1, l_rootinfo_index=449906
INV_QUANTITY_TREE_PVT: odab entering build_tree grade_code=4.167
INV_QUANTITY_TREE_PVT: In build_tree.   g_is_lot_control=TRUE
INV_QUANTITY_TREE_PVT: build_tree: l_revision_control=1
INV_QUANTITY_TREE_PVT: build_tree: l_asset_subs_only=2
INV_QUANTITY_TREE_PVT: build_tree: l_no_lpn_reservations=2
INV_QUANTITY_TREE_PVT: build_tree: l_onhand_source=3
INV_QUANTITY_TREE_PVT: build_tree: l_grade_code=4.167
INV_QUANTITY_TREE_PVT: build_tree: l_lot_expiration_date=25-JUN-22
INV_QUANTITY_TREE_PVT: build_tree: open c_lot_grade_MMS
INV_QUANTITY_TREE_PVT: build_tree: l_lot_expiration_control=1
INV_QUANTITY_TREE_PVT: build_tree: loop index=.
INV_QUANTITY_TREE_PVT: ... end of build_tree loop...
INV_QUANTITY_TREE_PVT:   BUILD_TREE Exited with status = S
INV_QUANTITY_TREE_PVT:   print tree: number=1 id=449906 for item=3994551 org=217
INV_QUANTITY_TREE_PVT:   _____start of tree 449906
INV_QUANTITY_TREE_PVT:      Node Rev  Lot       Sub       Loc    Lpn        qoh   rqoh     qr     qs    att    atr qs_adj1 Rsv Marked
INV_QUANTITY_TREE_PVT:     ----------------------------------------------------------------------------------------------------------
INV_QUANTITY_TREE_PVT:      Item ...  ...       ...       ...    ...          0      0      0      0      0      0       0 Y  FALSE
INV_QUANTITY_TREE_PVT:     ----------------------------------------------------------------------------------------------------------


1) Create Item (Say ITEM1) with Lot Controlled as Full Control and Grade Control Enabled. Give Default grade - Lets Say A.
2) Assign the item to Organization (Say O1).
3) Receive some onhand quantity in grade A and Lot 'XXXX' using Misc Receipt.
4) Create a Sales Order - ZZZZ with warehouse O1, Grade B, quantity 3.
5) Do a Pick Release with Auto Allocate to NO.
6) In the transact move order try to allocate the line.
7) System throws error.


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

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