Inventory Standard Datafix Instruction #5: Fixing Serial Numbers With Leading Or Trailing Spaces (Doc ID 1376548.1)

Last updated on SEPTEMBER 07, 2023

Applies to:

Oracle Inventory Management - Version 11.5.10.2 and later
Oracle Warehouse Management - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
mtl_serial_numbers
Spaces / White-space / Padded / Need Trimming

Goal

This document provides the detailed instructions for fixing wrong data caused by Serial Numbers having Trailing and/or Leading Spaces. Also this document will show all the available information regarding the Root Cause of this data corruption.

Please follow up this document in the following order:
A. Identification Scripts: This will confirm if you are having this data corruption.
B. Verifying your file versions: This will allow you and support to confirm if you are already in a known fixed version.
C. Root Cause Analysis. It shows all the relevant information about this issue Root Cause.
D. Datafix Intructions. It will provide steps for fixing the data corruption.