Background Processing/Transaction Processor Error On Transactions Interface And Pending Material Transactions Tables (Doc ID 1220763.1)

SELECT 'MTL_MATERIAL_TRANSACTIONS_TEMP' table_name, COUNT(*)
FROM MTL_MATERIAL_TRANSACTIONS_TEMP
WHERE ERROR_CODE = 'Transaction Processor Error'
AND TRANSACTION_BATCH_ID IS NOT NULL
UNION
SELECT 'MTL_TRANSACTIONS_INTERFACE' table_name, COUNT(*)
FROM MTL_TRANSACTIONS_INTERFACE
WHERE ERROR_CODE = 'Transaction Processor Error'
AND TRANSACTION_BATCH_ID IS NOT NULL ;


SELECT 'MTL_MATERIAL_TRANSACTIONS_TEMP' table_name, COUNT(*)
FROM MTL_MATERIAL_TRANSACTIONS_TEMP
WHERE ERROR_CODE = 'Transaction Processor Error'
AND TRANSACTION_BATCH_ID IS NOT NULL
UNION
SELECT 'MTL_TRANSACTIONS_INTERFACE' table_name, COUNT(*)
FROM MTL_TRANSACTIONS_INTERFACE
WHERE ERROR_CODE = 'Transaction Processor Error'
AND TRANSACTION_BATCH_ID IS NOT NULL ;





UPDATE MTL_MATERIAL_TRANSACTIONS_TEMP
SET TRANSACTION_BATCH_ID = NULL,
    PROCESS_FLAG = 'Y',
    LOCK_FLAG = 'N',
    ERROR_CODE = NULL,
    TRANSACTION_MODE = 3
WHERE ERROR_CODE = 'Transaction Processor Error'
  AND Transaction_Temp_id = &YourTransactionID;
 
 
UPDATE MTL_TRANSACTIONS_INTERFACE
SET TRANSACTION_BATCH_ID = NULL,
    PROCESS_FLAG = 1,
    LOCK_FLAG = 2,
    ERROR_CODE = NULL,
    TRANSACTION_MODE = 3
WHERE ERROR_CODE = 'Transaction Processor Error'
AND Transaction_Interface_id = &YourTransactionID;