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.
- 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';
- If the codes are not already mapped, map the project UOMs to the warehouse (conformed) UOMs coded in FSM.