My Oracle Support Banner

Same Item Different UOMs By Org (Doc ID 1669983.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Demantra Demand Management - Version and later
Information in this document applies to any platform.


Customer has Demantra integrated with EBS and VCP

They have a configuration of one Item having different UOM for different ORG (item= A /Org=1 have one conversion and then item=A /Org=2 have different conversion)
How does demantra handle uom which are different in different orgs?

Specific details to their case is that the primary_uom_code in EBS is not a Master Control attribute. It is an organization control attribute.
The have an item 75300 which has primary_uom_code 'M' in org:POL and FT in the rest of the orgs.
When they ran the UOM conversions for Demantra they saw conversions on FT UOM column(EBSUOM100) has 3.28084 and in M UOM column(EBSUOM103) as 1.

Since the conversion factor is at item level and not at item org combination level how do they know for which org the conversion is for.
For eg if they have shipped 100 qty from org PRD:065 in FT and now when they use the token in the worksheet it will multiple by 3.28084 and show as 328.084

Also EBSUOM101 in KG has conversion value blank.
EBSUOM102 is LB has conversion value blank.

Customer also mentions that when they run the UOM conversion it randomly selects one ORG to use as conversion
SO say, if an item had Meters in one org and Centimeters in another ORG, when they run the UOM, they do not know which ORG UOM is selected ( Meters or centimeters to do the conversion.


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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.