Serial Number With Trailing Or Leading Spaces Which Are Not Returned By Trailing Space Diagnostics
Last updated on MAY 12, 2016
Applies to:Oracle Inventory Management - Version 18.104.22.168 and later
Information in this document applies to any platform.
Duplicate, Serial Number, Trailing Space, Leading Space
Some Serial Numbers are showing Trailing/Leading Spaces, but following query returns no rows, or these serials don't appear.
The standard/regular datafixes (from Note 568012.1 - FAQ: Inventory Standard Datafixes) are not working in this case.
select * from mtl_serial_numbers
where length(serial_number) != length(trim(serial_number));
In this particular case, some serial numbers have been stored in MTL_SERIAL_NUMBERS with TAB Characters.
There may be other non-printing characters besides the TAB.
The issue can be reproduced by following the steps below:
1º. Copying serials (or whatever char text) from an Excel file or other formatted text (e.g. Wordpad, MS Word, a Bug)
2º. Pasting them into the Serial Number field.
3º. Save data.
ASCII 9 = TAB (Horizontal TAB)
This may come from EXCEL TAB, or TXT TAB
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms