My Oracle Support Banner

When Loading Serial Number Interface Error 'Value Too Long For Type Character Varying(10) CONTEXT: COPY stage_ib_shipment_serial_nbr' (Doc ID 2390774.1)

Last updated on APRIL 30, 2018

Applies to:

Oracle Warehouse Management Enterprise Edition Cloud Service - Version 8.0.2 and later
Information in this document applies to any platform.

Symptoms

On : 8.0.2 version, Scheduled Jobs

When attempting to Load Inbound Shipment Serial Number interface file (ISN),
the following error occurs.

ERROR
-----------------------
1) "load_stage data failed with error code: 1 ERROR: value too long for type character varying(10) CONTEXT: COPY stage_ib_shipment_serial_nbr, line 2, column item_part_e: "ITEM_PART_E" Error loading data "
2) "Duplicate serial numbers found ITEM_CODE/SERIAL_NBR"

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create ISN file that should contain Shipment Number, LPN, Item, Serial Nbrs
2. Go to Input Interface
3. Select Entity: IB Shipment Serial Nbr
4. Upload a file and run the interface

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.