Pending Transactions MTL_MATERIAL_TRANSACTIONS_TEMP MMTT Error Messages, Meanings and Solutions
(Doc ID 1070343.1)
Last updated on SEPTEMBER 07, 2023
Applies to:
Oracle Inventory Management - Version 11.5.9 and laterOracle Shipping Execution - Version 12.2.9 to 12.2.9 [Release 12.2]
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 |