Import User Defined Attribute Units of Measure (UOM) Using Excel Import (Doc ID 367620.1)

Last updated on MARCH 14, 2016

Applies to:

Oracle Product Hub - Version 11.5.10.0 and later
Information in this document applies to any platform.
This document includes all versions of Oracle EBS 11i and R12 and later


Goal

In Product Lifecycle Management (PLM) and Product Information Management (PIM), how does one import user defined attributes, using Excel Import, which have Unit of Measure (UOM) conversions.

When creating a numeric User Defined Attribute (UDA) in PLM and PIM, you can specify that a Unit of Measure (UOM) be associated to the attribute (ie. Weight =10, UOM = LBS). However, when performing an import of data for the UDA's via the Excel Item Import - there is no way to specify the UOM value for these types of attributes. Once the import is completed, the Unit of Measure simply defaults to the base UOM value.

Solution

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