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;