ORA-06502 in SUPVWEDT Form When Department Name Contains More Than 31 Characters

(Doc ID 1953162.1)

Last updated on AUGUST 17, 2016

Applies to:

Oracle Retail Merchandising System - Version 13.1.5 to 13.1.9 [Release 13.1]
Information in this document applies to any platform.


In Oracle Retail Merchandising System (RMS) 13.1.x, the below error is encountered when trying to create, view, or edit a supplier when the client_name for a department in dynamic_hier_code contains more than 31 characters:

Steps to Reproduce:

  1. Add a client_name for DEPARTMENT that is longer than 31 bytes. For example:
    update dynamic_hier_code set client_name='DEPARTMENT THAT IS TOO LONG TO USE HERE' where rms_name='DEPARTMENT';
  2. Navigate:  Control > Supplier.
  3. In the Action field, select New, View, or Edit.
  4. Note the error:  ORA-06502: PL/SQL: numeric or value error: character sting buffer too small returned by program unit LANGUAGE_SQL.GET_CODE_DESC


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms