My Oracle Support Banner

Pending Transactions MTL_MATERIAL_TRANSACTIONS_TEMP MMTT Error Messages, Meanings and Solutions (Doc ID 1070343.1)

Last updated on MAY 06, 2019

Applies to:

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


Purpose

This guide has been created to give a clear explanation of the common errors found in Pending Transactions MTL_MATERIAL_TRANSACTIONS_TEMP (MMTT) and how to resolve these errors.

This is a working document and as new solutions or issues come to light, they will be added to the document.

Troubleshooting Steps

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
Purpose
 This guide has been created to give a clear explanation of the common errors found in Pending Transactions MTL_MATERIAL_TRANSACTIONS_TEMP (MMTT) and how to resolve these errors.
Troubleshooting Steps
 Script to pick-up errors
 Script to reset locked MMTT transactions
 Table of common error messages and reasons errors occur
 Possible Solutions
 1) An error occurred while relieving reservations.
 2) Calling material processor to process 1 row(s) under header ID.
 3) The MMTT.new_average_cost field is null or zero.
 4) Lot numbers are missing for lot controlled items.
 5) For this transaction row the serial records are missing.
 6) Invalid Serial number transaction quantity.
 7) Negative balances not allowed. 
 8) No open period found for date entered .
 9) Oracle error. 
 10) Organization ID is either blank or invalid.
 11) Status not applicable for this subinventory.
 12) The material pick release and pick confirm process completed with errors. 
 13) Total Lot Transaction Quantity does not Match Transaction Quantity.
 14) Total serial numbers does not match the transaction quantity.
 15) Transaction date cannot be a future date.
 16) Transaction quantity has an incorrect sign for the given transaction.
 17) The expenditure organization information is invalid.
 18) The item revision is not valid.
 19) The value of expiration date is required.
 20) The Subinventory record is missing in MTL_SECONDARY_INVENTORIES for the organization.
 21). How to verify if pending WIP Completion and WIP Issue transactions in MMTT are duplicates or not
 Transaction Codes
 SOURCE_TYPE_ID
 TRANSACTION_TYPE_ID
 TRANSACTION_ACTION_ID
References

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