TRANSACTION_MODE,LOCK_FLAG,PROCESS_FLAG,TRANSACTION_STATUS in MTI or MMTT

转载:http://blog.csdn.net/pan_tian/article/details/7899178

TRANSACTION_MODE,LOCK_FLAG,PROCESS_FLAG in MTI(MTL_TRANSACTIONS_INTERFACE) or MMTT(MTL_MATERIAL_TRANSACTIONS_TEMP)

* For transactions stuck in MMTT
update mtl_material_transactions_temp
set process_flag = 'Y',
lock_flag = NULL ,
Transaction_mode = 3  ,
Error_code = NULL ,
Error_explanation = NULL
where transaction_header_id = &transaction_header_id
and error_code is not NULL;
 
*For transactions stuck in MTI
update mtl_transactions_interface
set process_flag =  1,
lock_flag = NULL ,
Transaction_mode = 3 ,
Error_code = NULL ,
Error_explanation = NULL
where transaction_header_id = &transaction_header_id
and error_code is not NULL;

TRANSACTION_MODEMeaningDescription    NULL or 1Online ProcessingOnline processing is used by the Oracle Applications to immediately process records. This does not require that a concurrent program be run. The Transaction Manager does not process transactions marked for online processing. 2Concurrent ProcessingTransactions marked as concurrent transaction mode are processed by a dedicated transaction worker to explicitly process a set of transactions. The Transaction Manager does not process transactions marked for concurrent processing. 3Background ProcessingInterface transactions marked for Background processing will be picked up by the transaction manager polling process and assigned to a transaction worker. These transactions will not be processed unless the transaction manager is running. 8Internal Processing (Not visible in the pending transactions form)Transaction mode 8 is not a mode normally visible to the user as it is used for internal processing.  Transactions with this mode are not visible in the Pending transactions form. Transaction_mode of 8 is used internally to identify if records came from the interface table to the pending table or came directly into the pending table.  LOCK_FLAGMeaningDescription 1LockedFlag indicating whether the transaction is locked by the Transaction Manager or Workers.this prevents two different Workers from processing the same transaction; You should always specify ’2’ 2 or NULL or 'N'NOT Locked  PROCESS_FLAGMeaningDescription 1 or YReadyTransaction is ready to be processed by the Transaction Manager or Worker (’1’ for ready, ’2’ for not ready); if the transaction fails for some reason, the Transaction Worker sets the value of PROCESS_FLAG to ’3’. 2 or NULLNOT Ready EError      

TRANSACTION_STATUSMeaning1 or NullDefault behavior2Save only3Ready to processFor Move Order case, As soon as a move order is allocated, a record is inserted into the MTL_MATERIAL_TRANSACTIONS_TEMP table.  The column TRANSACTION_STATUS keeps track of the progress of the move order.

These are the current values for TRANSACTION_STATUS:

STATUS 1 = PENDING
STATUS 2 = ALLOCATED 
STATUS 3 = TRANSACTED / This is where went into internal processing and waiting for transaction manager to run if transaction_mode is 3 / background.