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:
Oracle Warehouse Management - Version 12.2.5 and laterInformation in this document applies to any platform.
Symptoms
NOTE: |
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
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
Symptoms |
Cause |
Solution |
References |