How to Resubmit Unprocessed Transactions Stuck in the MTL_MATERIAL_TRANSACTION_TEMP Table (文档 ID 210096.1)

转到底部

In this Document

Goal

Solution

Instructions for resubmitting Pending / Unprocessed Transactions

For screen resubmission :

To resubmit all Pending Transactions from the Applications:

For resubmission via SQL*Plus use one of the following scripts.

Script 1 - All Transactions:

Script(s) 2 - MMTT.TRANSACTION_HEADER_ID and several MMTT.TRANSACTION_HEADER_ID's:

References

APPLIES TO:

Oracle Inventory Management - Version 11.5.10.0 and later
Information in this document applies to any platform.
This document includes all versions of Oracle E-Business Suite 11i and Release 12.

GOAL

This document provides assistance for processing unprocessed Transactions stuck or errored in Pending Transactions and the corresponding MTL_MATERIAL_TRANSACTION_TEMP (MMTT) table.

SOLUTION

Instructions for resubmitting Pending / Unprocessed Transactions

Pending Transactions may be resubmitted through the Pending Transactions screen or via SQL*Plus.

Note: Allocated move orders also create pending transactions but these are not processed via the pending transaction form. The transact move order form is used for Non-WMS. WMS uses tasks to transact.

For non-WMS: Allocated move orders are transacted via the Inventory > Move Orders > Transact Move Orders form. For more details, seeNote 1136354.1 - Pending Transactions (MTL_MATERIAL_TRANSACTIONS_TEMP) Preventing Period Close?
For WMS: Allocated move orders are transacted via Tasks, not the transact move order form.

For screen resubmission :

Navigation Inventory>Transactions>Pending Transactions
Click the checkbox under the "Submit" column to select specific rows.
Click the Save icon

To resubmit all Pending Transactions from the Applications:

Navigation Inventory > Transactions > Pending Transactions > Tools > Submit All
This will choose all records for resubmission.
Click the Save icon.

For resubmission via SQL*Plus use one of the following scripts.

Please note that Oracle requires that a back up of the tables involved be completed prior to modifying any data at the table level in any way.

Script 1 will resubmit all transacations.
Script 2 will resubmit tranasactions with the same TRANSACTION_HEADER_ID in
the MTL_MATERIAL_TRANSACTIONS_TEMP (MMTT) table.

After these updates, issue a COMMIT;

The Transaction Processor will then pick up and process the transactions.

Script 1 - All Transactions:

											Update MTL_MATERIAL_TRANSACTIONS_TEMP

Set PROCESS_FLAG = 'Y',

LOCK_FLAG = 'N',

TRANSACTION_MODE = 3,

ERROR_CODE = NULL,

ERROR_EXPLANATION = NULL

Where PROCESS_FLAG in ('Y','E');

Script(s) 2 - MMTT.TRANSACTION_HEADER_ID and several MMTT.TRANSACTION_HEADER_ID's:

Script 2.a Resubmit all records with the same MMTT.TRANSACTION_HEADER_ID:

											Update MTL_MATERIAL_TRANSACTIONS_TEMP 

Set PROCESS_FLAG = 'Y', 

LOCK_FLAG = 'N' , 

TRANSACTION_MODE = 3, 

ERROR_CODE = NULL, 

ERROR_EXPLANATION = NULL 

Where TRANSACTION_HEADER_ID = &txn_header_id;

Script 2.b Resubmit all records within several MMTT.TRANSACTION_HEADER_ID's:

											Update MTL_MATERIAL_TRANSACTIONS_TEMP 

Set PROCESS_FLAG = 'Y', 

LOCK_FLAG = 'N' , 

TRANSACTION_MODE = 3, 

ERROR_CODE = NULL, 

ERROR_EXPLANATION = NULL 

Where TRANSACTION_HEADER_ID in (&header_id1, &header_id2 )

REFERENCES

NOTE:102878.1 - Inventory Transactions Guide
NOTE:1136354.1 - Pending Move Order Allocation Transactions (MTL_MATERIAL_TRANSACTIONS_TEMP) Preventing Period Close?

MTL MATERIAL TRANSACTION TEMP

APPLIES TO:

GOAL

SOLUTION

Instructions for resubmitting Pending / Unprocessed Transactions

For screen resubmission :

To resubmit all Pending Transactions from the Applications:

For resubmission via SQL*Plus use one of the following scripts.

Script 1 - All Transactions:

Script(s) 2 - MMTT.TRANSACTION_HEADER_ID and several MMTT.TRANSACTION_HEADER_ID's:

REFERENCES