My Oracle Support Banner

Deleting Free Form Text UDAs With More Than 30 Characters Is Not Possible Using RIB XItem Interface (Doc ID 2492481.1)

Last updated on APRIL 14, 2021

Applies to:

Oracle Retail Merchandising System - Version 16.0.1 and later
Information in this document applies to any platform.


Following error occurs upon deleting Free Form text UDA(User Defined Attributes) from RIB XItem interface.

"{call RMSSUB_XITEM.CONSUME(?,?,?,?)}: [setInParms] Inserted value too large for column: "THIS STRING HAS MORE THAN THIRTY CHARACTERS"

Steps To Reproduce:

  1. Create a new item using RIB XItem API.
  2. Check the RMS tables ITEM_MASTER and UDA_ITEM_FF.
  3. Try to delete the Free Form text UDA using RIB XItem API.
  4. Note the above error.


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.