You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

We are using DBAPI for UOM conversion for different UOM's getting error?

edited Jan 16, 2024 7:32PM in Product Master Data Management 1 comment

Summary:

Hi team,

Basically my intention is whenever business create Purchase order with line level UOM as "Dozen" and for that item the primary UOM is "Each" in Item master. I want the conversion rate for that difference UOM's.

The below DBAPI for UOM conversion for different UOM's like PO line level UOM and Item Primary UOM.

Is there any in Oracle fusion cloud for the same?

Please let me know id anyone know this regard.

SELECT 

inv_convert.inv_um_convert_new ( 

                          item_id                   => 100000065508945

                         ,precision                => NULL  

                         ,from_quantity     => 1             

                         ,from_unit              =>'DOZ'

                         ,to_unit                    =>'Ea'

                         ,from_name           => NULL

                         ,to_name                 => NULL

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!