Move Any LPN Returning Incorrect Qty From Call Inv_transfer_order_pvt.get_primary_quantity

(Doc ID 2318427.1)

Last updated on OCTOBER 17, 2017

Applies to:

Oracle Warehouse Management - Version 12.2.5 and later
Information in this document applies to any platform.

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

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