Transactions Interface MTL_TRANSACTIONS_INTERFACE MTI Error Messages, Meanings, and Solutions
(Doc ID 1063689.1)
Last updated on SEPTEMBER 23, 2024
Applies to:
Oracle Inventory Management - Version 11.5.10 and laterInformation in this document applies to any platform.
This document includes all versions of Oracle EBS 11i and R12 and later
Purpose
This guide has been created to give a clear explanation of the common errors found in Transactions Interface MTL_TRANSACTIONS_INTERFACE (MTI) 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 Transactions Interface MTL_TRANSACTIONS_INTERFACE (MTI) and how to resolve these errors. |
| Troubleshooting Steps |
| Script to pick-up errors |
| Script to reset locked MTI transactions |
| Table of common error messages and reasons errors occur |
| Possible Solutions |
| 1) An error occurred while relieving Reservations |
| 2) CSTPACIT.COST_DET_VALIDATE: An invalid cost change is associated with the item being transacted |
| 3) Error. CSTPACIT.cost_det_move |
| 4) Error: (Lotrecords) For this transaction row either the lot records are missing or the lot quantity does not match the transaction quantity |
| 5) For this transaction row the serial records are missing |
| 6) Invalid Serial Number |
| 7) Invalid Item |
| 8) Code:Item control mismatch |
| 9) Negative balances not allowed |
| 10) No open period found for date entered |
| 11) Oracle error |
| 12) Organization ID is either blank or invalid |
| 13) Status not applicable for this subinventory |
| 14) Transaction date cannot be a future date |
| 15) Transaction quantity has an incorrect sign for the given transaction |
| 16) The expenditure organization information is invalid |
| 17) The item revision is not valid |
| 18) The value of expiration date is required. Need to add EXPIRATION_DATE to the lots |
| 19) Freight code is not valid. Please re-enter |
| 20) Price was not found on price list <Price List Name> for this item <part number> and uom <UOM> |
| Transaction Codes |
| SOURCE_TYPE_ID |
| TRANSACTION_TYPE_ID |
| TRANSACTION_ACTION_ID |
| References |