My Oracle Support Banner

Transactions Interface MTL_TRANSACTIONS_INTERFACE MTI Error Messages, Meanings, and Solutions (Doc ID 1063689.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Inventory Management - Version 11.5.10 and later
Information 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) 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
 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.