My Oracle Support Banner

Item Specific Uom Conversion Rate Is Not Correct In Msc.msc_uom_conversions (Doc ID 2390512.1)

Last updated on APRIL 24, 2018

Applies to:

Oracle Collaborative Planning - Version 12.1.3 and later
Information in this document applies to any platform.


In an Instance

Item AAA1 primary UOM = KIT. A supplier provides its data for supply commits for the item in CTN units of measure. Both KIT and CTN are UOM in Quantity class with Each being a base UOM for the class.
There are standard UOM converstion as follows
1) CTN = 1 * Each
2) KIT = 1* Each

There are also item specific intra-class conversions as follows:
1) CTN = 3 * Each
2) KIT = 3 * Each

From the above I expect the converstion from CTN to KIT as follows
1) from CTN to Each, for example 10 CTN = 3* 10 = 30 Each;
2) from Each to KIT, for example 30 Each = 30/3 = 10 KIT.

So, actually 1 CTN = 1 KIT.

But in msc.msc_sup_dem_entries for the item AAA1, see quantity = 200 CTN (exactly what the supplier provided) and tp_quantity = 600 KIT - which is 3 times 200 - and it should show 200.

On retrieving data from msc.msc_uom_conversions for the item and class "Quantity" I can see convercion_rate = 3 for CTN and for KIT. With line for CTN having default_conversion_flags = Y and the line for KIT having it N.
When msc.msc_sup_dem_entries is populated with data by Supply Chain Collaboration Load, for CTN is used.
As a result, received supplier capacity which is 3 times greater than actually confirmed by the supplier.  --- But 3 is a rate from CTN to Each and not from CTN to KIT.

We examined this case and find the following:

When we got the bug fix for bug 8676816 - we fixed the case where Intra-class conversions were fixed but that fix does not work for case when both Item UOM and Supplier UOM has non-default intra-class conversions

An item can have its specific UOM conversion but all such conversions are between the item primary UOM and the base UOM (!) of a UOM class only.
For such an example Bug 8676816 was created and mcs_x_util amended, i.e. it returns the correct rate only when one of the UOM used is the base unit of a class.


To view full details, 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 a vibrant support community of peers and Oracle experts.