My Oracle Support Banner

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

Last updated on JULY 13, 2018

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.