Translate

Monday, November 16, 2015

'Error_code as 'Transaction processor error and Error Explanation as 'Negative balances not allowed'

'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';

No comments:

Post a Comment

Text Message

Item Rate Update for Stock In Trade - Returnable Receive/Return (Loan)

  Stock In Trade - Returnable Receive/Return (Loan)