Move Any LPN Returning Incorrect Qty From Call Inv_transfer_order_pvt.get_primary_quantity (Doc ID 2318427.1)

Last updated on JULY 08, 2020

Applies to:

Symptoms

On : 12.2.5 version, Materials Management

Move any LPN returning incorrect qty from call inv_transfer_order_pvt.get_primary_quantity

Item Data
##################
Item = 031584
primary UOM = EA
Item level UOM Conversion Rate between EA & pll = 1540

PO DATA
###############
create PO for 100 pll of item 031584

Transaction
###############
* Receipt 2 pll in 2 LPN numbers LPN1 & LPN2
* Putaway LPN1 & LPN2 to INBOUND QA Locator
* Perform split LPN on LPN1 and remove 10 EA from the LPN into LPN 3

* use move any LPN to select a destination for the 3 LPNs
  * LPN2 & LPN3 both call the rules and find a locator LPN1 returns error WMS_LPN_UNAVAILABLE

Expected outcome all three LPNs can be putaway..

Analysis
####################

Log file shows call to "Inv_Transfer_Order_PVT.Trolins: Populated primary quantity:" returns value 1530.0054 The WMS allocation process allocate 1530 and the validation failed because it does not match 1530.0054..

Root Cause.. the call inv_transfer_order_pvt.get_primary_quantity contains the parameter PRECISION this is passed as NULL, when I have updated this to 0 the issues is resolved.

Cause

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