Re-Process the mtl_material_transactions_temp and MTL_TRANSACTIONS_INTERFACE
I am trying to Re-Process the mtl_material_transactions_temp and MTL_TRANSACTIONS_INTERFACE error data's using PLSQL
Following activities are performed
1. Update the mtl_material_transactions_temp
UPDATE apps.mtl_material_transactions_temp
SET process_flag = 'Y',
lock_flag = NULL ,
Transaction_mode = 3 ,
Error_code = NULL ,
Error_explanation = NULL
2. Update the MTL_TRANSACTIONS_INTERFACE
UPDATE apps.mtl_transactions_interface
SET process_flag = 1,
lock_flag = NULL ,
Transaction_mode = 3 ,
Error_code = NULL ,
Error_explanation = NULL
3. Create the concurrent request to execute the process "Process transaction interface"
APPS.FND_REQUEST.SUBMIT_REQUEST('INV',
'INCTCM',
null,
null,
FALSE);
Still I having the same error data's in mtl_material_transactions_temp and MTL_TRANSACTIONS_INTERFACE tables. Can you please anybody explain to me how to re-process the interfaces errors in Inventory module.