Error Updating Attribute Value Using Bulk Upload From Excel ORA-06502 numeric or value error character string buffer too small (Doc ID 2145853.1)

Last updated on MARCH 22, 2023

Applies to:

Symptoms

When attempting to update item attributes, using excel import process, the EGOIJAVA concurrent program completes with error.

Error
 Exception encountered processing one of the procedures in Process_Item_Interface_lines.
 error code : -6502
 error text : ORA-06502: PL/SQL: numeric or value error: character string buffer too small
 Returning x_retcode : E
 Setting all the *Unprocessed* rows (PROCESS_STATUS = 1) in EGO_BULKLOAD_INTF to PROCESS_STATUS = 3.
 COMMITing the error statuses for EBI Rows.
 EGO_BULKLOAD_ENTITIES.BulkLoadEntities ERRBUF => Error : -6502---ORA-06502: PL/SQL: numeric or value error: character string buffer too small

Steps
The issue can be reproduced at will with the following steps.
1. Create Import Format to include
2. Navigate: Development Manager > Batch Import > Import Items > Import from Excel
3. Create 1 record to UPDATE item 'TEST_UPLOAD_1'
4. Update attributes as required
5. Upload completes successfully, but attributes are not updated as expected.

Cause

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