My Oracle Support Banner

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


Symptoms

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

oracle error


Error: In Log

Set and get global variables for date,time,user,encoding,profile values
Error in get_profile_values
ERROR CODE = -6502
ERROR MESSAGE = ORA-06502: PL/SQL: numeric or value error: character to number conversion error

 

 

Steps
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.

Business Impact
Due to this issue, users cannot process transactions.

Verification
The following SQL verified the issue exists:

select error_code from MTL_TRANSACTIONS_INTERFACE
/
oracle error

Cause

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
Symptoms
Cause
Solution
References

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