UOM Conversion Error On MTL_TRANSATIONS_INTERFACE (Doc ID 2322486.1)

Last updated on MARCH 17, 2021

Applies to:

Symptoms

On Transaction Interface, following error occurs in inventory debug log

INV_TXN_MANAGER_GRP: org id=org_id item id=item_id rev=
INV_TXN_MANAGER_GRP: txn uom=pri_uom qty=pri_uom_qty
INV_TXN_MANAGER_GRP: sec uom= qty=sec_uom_qty
INV_TXN_MANAGER_GRP: validate_quantities: assigned sec uom=sec_uom
INV_TXN_MANAGER_GRP: validate_quantities: calling INV_CONVERT.WITHIN_DEVIATION
INV_CONVERT.within_deviation: p_organization_id : org_id
INV_CONVERT.within_deviation: p_inventory_item_id: item_id
INV_CONVERT.within_deviation: p_lot_number : REC
INV_CONVERT.within_deviation: p_precision : 5
INV_CONVERT.within_deviation: p_quantity : pri_uom_qty
INV_CONVERT.within_deviation: p_uom_code1 : pri_uom
INV_CONVERT.within_deviation: p_quantity2 : sec_uom_qty
INV_CONVERT.within_deviation: p_uom_code2 : sec_uom
INV_CONVERT.within_deviation: p_unit_of_measure1 :
INV_CONVERT.within_deviation: p_unit_of_measure2 :
INV_CONVERT.within_deviation: p_split_check :
INV_CONVERT.within_deviation: l_converted_sec_qty : l_converted_sec_qty
INV_CONVERT.within_deviation: secondary_default_ind : D
INV_CONVERT.within_deviation: l_converted_prim_qty : l_converted_prim_qty
INV_CONVERT.within_deviation: returning error for fixed item as both sec and pri converted qty are not matching
INV_TXN_MANAGER_GRP: validate_quantities: INV_CONVERT.within_deviation (ERROR)
INV_TXN_MANAGER_GRP: p_transaction_quantity: pri_uom_qty p_transaction_uom_code: pri_uom
INV_TXN_MANAGER_GRP: p_secondary_quantity: sec_uom_qty p_secondary_uom_code: sec_uom
INV_TXN_MANAGER_GRP: p_lot_number: REC p_inventory_item_id: item_id p_organization_id: org_id
INV_TXN_MANAGER_GRP: validate_quantities IN (lotcheck) - FAIL
INV_TXN_MANAGER_GRP: Error in validate_line :
INV_TXN_MANAGER_GRP: Error:User-Defined Exception
INV_TXN_MANAGER_PUB: Returned from inv_txn_manager_grp.validate_lines
INV_TXN_MANAGER_PUB: Error in Line Validatin
INV_TXN_MANAGER_PUB: Error in Line Validatin
INV_TXN_MANAGER_PUB: Failed Interface ID : 775 Item: item_idOrg : org_id
INV_TXN_MANAGER_PUB: All records failed after line validation

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. From custom program, Insert data MTL_TRASACTIONS_INTERFACE and MTL_TRANSACTION_LOTS_INTERFACE
2. Run Transaction Interface Manager, found the error

Cause

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