MTI (MTL_TRANSACTIONS_INTERFACE) Has Error Code 'Oracle Error' / Duplicates
(Doc ID 332211.1)
Last updated on APRIL 01, 2020
Applies to:Oracle Inventory Management - Version 11.5.9 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.
EXECUTABLE:INCTCW - Inventory transaction worker
Checked for relevance on 29-JUN-2014
Find transactions in the transaction open interface table (MTL_TRANSACTIONS_INTERFACE) with the following error.
Also find the following error in the log file.
Resubmitting the transactions does not allow them to process.
Error: In Table
Error: In Log
Error in get_profile_values
ERROR CODE = -6502
ERROR MESSAGE = ORA-06502: PL/SQL: numeric or value error: character to number conversion error
1. Goto Inventory > Transactions > Transaction Open Interface
2. The find window appears
3. Enter the query criteria.
4. Press Find.
5. The transactions appear showing the error.
Due to this issue, users cannot process transactions.
The following SQL verified the issue exists:
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