How to process records in mtl_material_transactions_temp

How to process records in mtl_material_transactions_temp

In this post , we will be discuss about how we can process the Pending or Stuck transaction in mtl_material_transactions_temp. This Table Store Information's about Those Inventory transactions which are still in Process or Error Out. After Processing Inventory Transactions move to mtl_material_transactions table and also hit the Stock or Other accounting Impact. To Close the Inventory Period We must need to Clear these Records in the mtl_material_transactions_temp table. Here below I will share some steps for How to process pending records in mtl_material_transactions_temp

 

 

 

4 Important Steps to process records in mtl_material_transactions_temp

Step1:- Select * from MTL_MATERIAL_TRANSACTIONS_TEMP Where transaction_type_id=5 and proces_flag =’E’;

 

This will show the Stuck Transactions in the MTL_MATERIAL_TRANSACTIONS_TEMP table

 

Step2:-  Validate Inventory Transaction Manager is running and if there are any records pending or in error in the inventory transactions interface. These can be queried via the Inventory Transactions Interface Inquiry screen.

 

Step3:- Resubmit the Error Records in the Inventory Transactions Open Interface.

 

Go to Inventory responsibility

 

Transactions ==>  Transaction Open Interface

 

select transaction_source_id , inventory_item_id, process_flag,error_code, error_explanation,transaction_source_type_id, organization_id from mtl_material_transactions_temp where process_flag = ‘E’ and transaction_source_id= ;

 Use this script to resubmit the Transactions:
update mtl_material_transactions_tempset process_flag = ‘Y’,lock_flag = ‘N’,transaction_mode= 3,error_code = NULL,error_explanation = NULL where process_flag = ‘E’