INVTRSNT Serial Number Transaction Register Truncates Serial Numbers To 23 Characters (Doc ID 1626163.1)

Last updated on OCTOBER 21, 2015

Applies to:

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

Symptoms

On : 12.1.3 version, Other Inventory Issues

ACTUAL BEHAVIOR
---------------
When using long serial numbers, more than 23 characters, the Serial Number Transaction Register Report truncates serial numbers to 23 characters.

The maximum length for a serial number in MTL_SERIAL_NUMBERS is set for 30 characters.



EXPECTED BEHAVIOR
-----------------------
The report should display the maximum permitted serial number length of 30 characters.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Serial Number Transaction Register report.
2. Notice that the serial number is truncated to 23 characters.

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