ERP物料一旦录入系统，它的物料单位就被固定，所有的事务处理都会将转换为主要单位进行处理，但单位的不同涉及到事务处理的数量和所有的价格，从而关联到订货量、发运量和物料清单等几乎所有内容，如果发现进入系统物料的单位错了就很难处理，当然最直接的方法就是重新编个新码进入系统维护正确的信息，把错误单位的物料信息转移到新编码上（采购订单或工单、库存事务、事务处理、发运事务、转账事务等），然后把原码失效。最根本的办法也是比较麻烦的办法是从数据库调出对应的表，修改错误的代码。具体内容如下：
一：mtl_system_items_b
物料单位：
select msib.inventory_item_id,--- 118473
msib.primary_uom_code,
msib.primary_unit_of_measure
from mtl_system_items_b msib
where msib.organization_id = 101
and msib.segment1 = 'J91797'
PRIMARY_UOM_CODE PRIMARY_UNIT_OF_MEASURE
㎡ 平方米
二：mtl_material_transactions
select mmt.transaction_id, mmt.transaction_uom
from mtl_material_transactions mmt
where mmt.organization_id = 101
and mmt.inventory_item_id = 118473
TRANSACTION_ID TRANSACTION_UOM
13624745 ㎡
三：po_lines_all
select *
from po_lines_all pll
where pll.item_id = 118473
and pll.org_id = 81
UNIT_MEAS_LOOKUP_CODE
平方米
平方米
四：po_line_locations_all
select *
from po_line_locations_all plla
where plla.po_line_id in (98101, 98437)
UNIT_MEAS_LOOKUP_CODE
平方米
五：rcv_transactions
select rt.transaction_id,
rt.unit_of_measure,
rt.uom_code,
rt.primary_unit_of_measure
from rcv_transactions rt
where rt.organization_id = 101
and rt.po_line_location_id = 292942
TRANSACTION_ID UNIT_OF_MEASURE UOM_CODE PRIMARY_UNIT_OF_MEASURE
285212 平方米 ㎡ 平方米
285213 平方米 ㎡ 平方米
六：rcv_shipment_lines
select rsl.shipment_line_id,
rsl.unit_of_measure,
rsl.primary_unit_of_measure
from rcv_shipment_lines rsl
where rsl.item_id = 118473
SHIPMENT_LINE_ID UNIT_OF_MEASURE PRIMARY_UNIT_OF_MEASURE
192989 平方米 平方米
七：mtl_onhand_quantities_detail
select moq.transaction_uom_code
from mtl_onhand_quantities_detail moq
where moq.inventory_item_id = 118473
TRANSACTION_UOM_CODE
㎡
/*******************************************************************/
更 新 代 码
/*******************************************************************/
----mtl_system_items_b
select msib.inventory_item_id, ---118473
msib.primary_uom_code,
msib.primary_unit_of_measure
from mtl_system_items_b msib
where msib.organization_id = 101
and msib.segment1 = 'J91797'
update mtl_system_items_b msib
set msib.primary_uom_code = 'M2'
where msib.organization_id = 101
and msib.segment1 = 'J91797'
---mtl_material_transactions
select mmt.transaction_id, mmt.transaction_uom
from mtl_material_transactions mmt
where mmt.organization_id = 101
and mmt.inventory_item_id = 118473
update mtl_material_transactions mmt
set mmt.transaction_uom = 'M2'
where mmt.organization_id = 101
and mmt.inventory_item_id = 118473
----rcv_transactions
select *
from po_lines_all pll
where pll.item_id = 118473
and pll.org_id = 81
select *
from po_line_locations_all plla
where plla.po_line_id in (98101, 98437)
select rt.transaction_id,
rt.unit_of_measure,
rt.uom_code,
rt.primary_unit_of_measure
from rcv_transactions rt
where rt.organization_id = 101
and rt.po_line_location_id = 292942
update rcv_transactions rt
set rt.uom_code = 'M2'
where rt.organization_id = 101
and rt.po_line_location_id = 292942
and rt.transaction_id in (285212,285213)
---mtl_onhand_quantities_detail
select moq.transaction_uom_code
from mtl_onhand_quantities_detail moq
where moq.inventory_item_id = 118473
and moq.organization_id = 101
update mtl_onhand_quantities_detail moq
set moq.transaction_uom_code
where moq.inventory_item_id = 118473
and moq.organization_id = 101
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/22420969/viewspace-660318/ ，如需转载，请注明出处，否则将追究法律责任。
