'Pending Transactions'
Transaction Pending in the MTL_MATERIAL_TRANSACTIONS_TEMP Table, if you are unable to clear please you this Data Fix Suggested by Oracle .
Error_code as 'Transaction
processor error and Error Explanation as 'Negative balances not allowed'
check MTL_MATERIAL_TRANSACTIONS_TEMP table
the values
- process_flag,
- lock_flag,
- transaction_mode
Then Use this Update Script :
Update MTL_MATERIAL_TRANSACTIONS_TEMP
Set PROCESS_FLAG = 'Y',
LOCK_FLAG = 'N',
TRANSACTION_MODE = 3,
ERROR_CODE = NULL
Where TRANSACTION_HEADER_ID = '& TRANSACTION_HEADER_ID';
------------------------------------------------------------------------------------------------------------
Hi,
ReplyDeleteWhich data fix you havent mentioned, I need to delete the data with same error and it is not being processed?
thanks,
/Z