Item Cost is not getting Calculated by Transaction UOM (Doc ID 2065094.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On : 12.2.3 version, Inventory Transactions

ACTUAL BEHAVIOR
---------------
Item cost is not getting by Transaction_uom as expected.

When doing a transaction for an item in PKT where as the primary UOM is EACH ( 1 PKT=1000 EACH) using the Process Transaction Interface to import the transaction with the quantity and unit price inserted in transaction UOM only. The average cost is calculated by the system in the primary UOM instead of the Transaction uom.

For example:

17 PKT 123.75 17000 EACH
100 PKT 123.75 100000 EACH
40 PKT 123.75 40000 EACH

When transacting 17 PKT where the cost of each PKT is 123.75 QAR. The system is taking the valuation of each item as 123.75 QAR. So pricing is showing (17*1000*123.75).


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