R12 - Upload Item Specific UOM Conversion

Hi,

Today i am posting how to upload item specific UOM conversion rates by using API.

Procedure : CREATE_UOM_CONVERSION  Is introduced in R12.1.3.

DECLARE
v_from_uom       VARCHAR2(200);
v_to_uom         VARCHAR2(200);
v_item_id        NUMBER;
v_uom_rate       NUMBER;
x_return_status  VARCHAR2(99);

BEGIN

  v_from_uom := 'DOZEN'; 
  v_item_id := '9999';
  v_uom_rate := '9';
  v_to_uom := 'EA';


  INV_CONVERT.CREATE_UOM_CONVERSION
                  (
                    p_from_uom_code => v_from_uom,
                    p_to_uom_code   => v_to_uom,
                    p_item_id       => v_item_id,
                    p_uom_rate      => v_uom_rate,
                    x_return_status => x_return_status
                  );
END;