My Oracle Support Banner

Transaction Cost Not Corrected For Uom Conversion Rate When Imported From Mti (Doc ID 1423119.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.


You insert a miscellaneous transaction line into mtl_transaction_interface with transaction uom= Ton,
transaction cost=4,76326-USD (for example), transaction_quantity=40.

Primary UOM is 'Kg' for this item.

You expect base_transaction_value to be 190,53-USD. But it comes as 190530,48-USD.

When you do the same transaction through miscellaneous transactions form, the base transaction value is 190,53-USD, as expected.

You are entering the transaction cost in mtl_transactions_interface same as unit cost of the item 4,76326.
So the calculation would be:
(QTY * UOM Conversion * Transaction Cost which 40 * 1000 *4,76326 ) = 190530.4.

The miscellaneous form and the mtl_transaction_interface are working the same.
The column in mtl_transactions_interface is called transaction_cost, therefore, the cost should be converted to match the
UOM entered. In Miscellaneous form, the unit cost is converted based on the entered UOM to the transaction cost.

In this example, the unit cost is 4,76326, when the transaction cost is converted for TON, it is recorded as 0.004763262.
Therefore, when you enter the cost in the MTL_TRANSACTIONS_INTERFACE it should be the same as 0.004763262
(which is converted to the the TON cost not KG cost).

This is not a bug, this is the intended functionality.

You can "workaround" the issue leaving Transaction_cost blank in the MTI table, the system gets default unit cost
associated with the inventory item.

But this is not the intended transaction to be performed. You have to give a transaction cost.


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

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