My Oracle Support Banner

SIOCS - ORA-12899: Value Too Large For Column (Doc ID 2956719.1)

Last updated on JUNE 22, 2023

Applies to:

Oracle Retail Enterprise Inventory Cloud Service - Version 22.1 to 23.1 [Release 22.1 to 23.1]
Information in this document applies to any platform.

Symptoms

When re-seeding 'Item' module, batch is ending with error: ORA-12899: value too large for column

ERROR
-----------------------
{"controlId":4435,"logMessage":"ORA-12899: value too large for column (actual: , maximum: )","item_id":"xxxxxxx","dataKey2":null,"dataKey3":null,"createTime":"YYYY-MM-DDThh:mm:ss","createUser":SIM01_MDI}

Steps to reproduce:

1. Log In EICS.
2. Admin>Technical Maintenance>Initial Data Load.
3. Item Header module (run delete) *Note - all depended modules should be deleted first
4. Item Header module - submit seed.

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
References


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