Configuring Project UOM for E-Business Suite

To get the project UOMs, use the SQL in the OLTP source database, and then map them to warehouse (conformed) UOMs coded in FSM if the codes are not already mapped.

  1. Use the following SQL to obtain the project UOMs:
    select lookup_code, meaning, description from fnd_lookup_values where lookup_type='UNIT' and LANGUAGE='US';
    
  2. If the codes are not already mapped, map the project UOMs to the warehouse (conformed) UOMs coded in FSM.