My Oracle Support Banner

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

Last updated on FEBRUARY 26, 2019

Applies to:

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

Symptoms

NOTE:
In the images below and/or the attached document, user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance).
Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

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


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