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

Accounts Receivable-AR setups in Oracle EBS Functional Financials - Apps R12

   1. Oracle Receivables -> Setup -> System ->System Options     a. Receivable GL related setup    b. Transaction and Customer rela...