TRANSACTION_MODE,LOCK_FLAG,PROCESS_FLAG,TRANSACTION_STATUS in MTI or MMTT

最新推荐文章于 2024-03-28 08:56:48 发布

田攀

最新推荐文章于 2024-03-28 08:56:48 发布

阅读量1.9w

点赞数 1

CC 4.0 BY-SA版权

文章标签： transactions processing manager header null interface

本文链接：https://blog.csdn.net/pan_tian/article/details/7899178

本文档介绍了如何处理在MTI（MTL_TRANSACTIONS_INTERFACE）和MMTT（MTL_MATERIAL_TRANSACTIONS_TEMP）中卡住的事务。提供了更新事务状态、锁定标志和处理标志的SQL语句，以便于事务流动。事务状态包括PENDING、ALLOCATED和TRANSACTED，当Transaction_mode设为3时，事务进入内部处理并等待交易管理器运行。

TRANSACTION_MODE,LOCK_FLAG,PROCESS_FLAG in MTI(MTL_TRANSACTIONS_INTERFACE) or MMTT(MTL_MATERIAL_TRANSACTIONS_TEMP)

* For transactions stuck in MMTT
update mtl_material_transactions_temp
set process_flag = 'Y',
lock_flag = NULL ,
Transaction_mode = 3 ,
Error_code = NULL ,
Error_explanation = NULL
where transaction_header_id = &transaction_header_id
and error_code is not NULL;

*For transactions stuck in MTI
update mtl_transactions_interface
set process_flag = 1,
lock_flag = NULL ,
Transaction_mode = 3 ,
Error_code = NULL ,
Error_explanation = NULL
where transaction_header_id = &transaction_header_id
and error_code is not NULL;