My Oracle Support Banner

Import Items "Load Interface Files for Import" Process Ends in Warning "Field in data file exceeds maximum length" (Doc ID 2660282.1)

Last updated on FEBRUARY 21, 2023

Applies to:

Oracle Fusion Inventory Management Cloud Service - Version 11.13.20.01.0 and later
Oracle Fusion Product Hub Cloud Service - Version 11.13.21.01.0 to 11.13.21.01.0 [Release 1.0]
Information in this document applies to any platform.

Symptoms

Process "Load Interface Files for Import" ends in a warning while
importing item CSV file upload with the following errors

ERROR
-----------------------
Error on table EGP_ITEM_CATEGORIES_INTERFACE, column ORGANIZATION_CODE.
Field in data file exceeds maximum length
Error on table EGP_SYSTEM_ITEMS_INTERFACE, column OUTSIDE_PROCESS_SERVICE_FLAG.
Field in data file exceeds maximum length

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Prepare ItemImportTemplate.xlsm for importing items.
2. Generate the zip file from above template.
3. Submit the "Load Interface Files for Import" with parameter "Import Items"


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!


In this Document
Symptoms
Cause
Solution


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