My Oracle Support Banner

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

Last updated on FEBRUARY 13, 2019

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).


Changes

 

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
Changes
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.