急﹐已經做了完工入庫為什么沒有使庫存增加?

coco1 · 发表于 2004-1-29 19:23

有否error信息?

lvxuezh · 发表于 2004-1-30 09:23

你首先要找到这个pengiing状态的transaction 是否对其他业务造成影响，如果造成影响，那是造成什么样的影响，比如库存之类，确认没有的话，下面只是参考，具体建议你提个tar:

Hi,

Development have advised us to proceed in the following manner:

Step 1:
---------
Create backup table as follows
/
create table mmtt_backup as
select *
from mtl_material_transactions_temp
where transaction_source_type_id = 5
and error_code = 'Transaction Processor Error'
/

Step 2:
--------
Query up records in this table.. there should be 96 records.

Step 3:
--------
Now use the following query to delete the records from MMTT
/
delete
from mtl_material_transactions_temp
where transaction_header_id in (select transaction_header_id from mmtt_backup)
/

This should delete 96 rows only...
Commit data after you are satisfied records deleted sucessfully.

Regards, Vinay
Oracle Support