查找待定事务处理

select b.segment1,b.description,costed_flag,transaction_group_id,a.inventory_item_id,a.creation_date
from inv.mtl_material_transactions a,
mtl_system_items b
where costed_flag in ('N','E')
and a.inventory_item_id=b.inventory_item_id

--待定事务
select b.segment1,b.description,costed_flag,transaction_group_id,a.inventory_item_id,a.creation_date
from inv.mtl_material_transactions a,
mtl_system_items b
where costed_flag in ('N','E')
and a.inventory_item_id=b.inventory_item_id

update inv.mtl_material_transactions
set costed_flag='N',transaction_group_id=NULL
WHERE COSTED_FLAG IN ('N','E')

务处理开放接口
接口表： MTL_TRANSACTIONS_INTERFACE
物料出入库可从这个表进行处理,如有批次控制，其信息写在
MTL_TRANSACTION_LOTS_INTERFACE接口表。

重新处理物料接口未处理数据:
update MTL_TRANSACTIONS_INTERFACE mti
set mti.transaction_mode=3,
mti.lock_flag=2,
mti.process_flag=1,
mti.error_code=null,
mti.error_explanation=null
where mti.transaction_interface_id=29369973

Update MTL_MATERIAL_TRANSACTIONS_TEMP
Set PROCESS_FLAG = 'Y',
LOCK_FLAG = 'N',
TRANSACTION_MODE = 3,
ERROR_CODE = NULL
Where transaction_header_id='24233328'
and transaction_temp_id='24238322'
and inventory_item_id=2916

delete WIP_COST_TXN_INTERFACE
where creation_date > '21-9月-2006'
and creation_date < '22-9月-2006'
and process_status=1

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/133041/viewspace-438525/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/133041/viewspace-438525/