Home » Applications » Oracle Fusion Apps & E-Business Suite » UOM conversion (r12)
UOM conversion [message #463005] Tue, 29 June 2010 03:50
lokeshsurana
Messages: 212
Registered: April 2010
Location: India
Senior Member
the requirement is as ...

on custom form user can choose any UOM for item

i need to find its secondary UOM and convert the user entered UOM and items secondary UOM by checking inter,intra and standard UOM tables

I try by using UOM conversion api as
Declare
v_Rate Number(30,23);
v_suom    varchar2(20)  default 'BK';---runtime value pick
v_puom    varchar2(20)  default 'KG';--runtime value pick
v_itemid  number default  '12345';--runtime itemid pick
Begin
v_rate := inv_convert.inv_um_convert_new ( 
                           item_id                    => v_itemid
                          ,precision                 => NULL  
                          ,from_quantity      => 1             
                          ,from_unit               => v_suom
                          ,to_unit                     => v_puom
                          ,from_name            => NULL
                          ,to_name                  => NULL
                          ,capacity_type        => 'U'
                          );      

end;


but this code not work for this...
which thing need to modify
Previous Topic: new item instance
Next Topic: Is there any api or open iterface to create request for quotation
Goto Forum:
  


Current Time: Fri Apr 26 21:40:22 CDT 2024