Serial Number With Trailing Or Leading Spaces Which Are Not Returned By Trailing Space Diagnostics (Doc ID 1369230.1)

Last updated on MAY 12, 2016

Applies to:

Oracle Inventory Management - Version 11.5.10.0 and later
Information in this document applies to any platform.
Duplicate, Serial Number, Trailing Space, Leading Space


Symptoms

Problem

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.

Steps

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

Cause

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