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 FEBRUARY 13, 2019

Applies to:

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


On : 8.0.2 version, Scheduled Jobs

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

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"

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




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.