My Oracle Support Banner

Serial Number Corrupted With A Non-Printable Character In Mtl_serial_numbers Cannot Be Used On Transactions (Doc ID 2996178.1)

Last updated on JANUARY 05, 2024

Applies to:

Oracle Inventory Management - Version 12.2.7 and later
Information in this document applies to any platform.


A non-printable character has been appended to the serial accidentally. When users try to use this serial on transactions, they are unable to view onhand or enter them on the Serials form. 

1. SQL developer > Run below queries >

2. See a lot of serials impacted in both tables.
3. Some of these serials are associated to onhand quantity and cannot be entered on transactions due to the invalid character.


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

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