My Oracle Support Banner

Querying An Item In PIM Shows Wrong Unit Of Measure After Updating The UOM Attribute Using API EGO_USER_ATTRS_DATA_PUB.Process_User_Attrs_Data (Doc ID 2321853.1)

Last updated on FEBRUARY 26, 2019

Applies to:

Oracle Product Hub - Version 12.1.2 and later
Information in this document applies to any platform.


In the images below and/or the attached document, user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance).
Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

Querying an item in PIM is showing wrong unit of measure when the unit of measure attribute is updated by the public API EGO_USER_ATTRS_DATA_PUB.Process_User_Attrs_Data.

If passing 1 FT to the API then the application shows 1 FT in the application but if 1 IN is passed to the API, then PIM shows 12.00000048 IN in the application.
FT is the base uom of the class, it works for the base uom but not for any other uom (like IN) that is not base uom.

FT = Feet, IN = Inches
Standard UOM conversion between Inch and Feet:
1 Inch = .08333333 Feet i.e 1 Feet = 12.00000048 Inches

User runs the API "EGO_USER_ATTRS_DATA_PUB.Process_User_Attrs_Data" with the below parameters, it shows 12.00000048 IN instead of 1 IN.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.