Item CFA Updates Fail with "value too large for column" when the Data Entered Matches Column Maximum Length
(Doc ID 3052960.1)
Last updated on OCTOBER 14, 2024
Applies to:
Oracle Retail Merchandising Foundation Cloud Service - Version 24.0 and laterInformation in this document applies to any platform.
Symptoms
On : 24.0.201.6 version, Merch - Inventory Movement
Problem Statement:
-------------------
Item CFA Updates Fail with "value too large for column" when the data entered matches the configured column maximum length.
Steps to Reproduce:
-------------------
Steps for recreation:
1. have a CFA group with varchar2 field attribute with max length defined as 250.
2. Try updating value for this field with 250 characters through UI and ensure that there are at atleast couple of single quotes(') in the text.
3. Download this item and then try updating the value for the same via induction.
4. Observe the error - Error ORA-12899: value too large for column "RMS01"."ITEM_MASTER_CFA_EXT"."VARCHAR2_5" (actual: 251, maximum: 250)
returned by program unit CFA_SQL.PERSIST_DATA.
As a workaround, customer can try to reduce the length of the text stored in these columns of item_master_cfa_ext table to be of around 240 characters in total where ever it is exceeding 240. Post this, when they upload the data, load should go through fine.
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 |