Error Message Occurs When Editing Partner Information: "ORA-06502 : PL/SQL : Numeric or Value Error"

(Doc ID 1951028.1)

Last updated on AUGUST 17, 2016

Applies to:

Oracle Retail Merchandising System - Version 13.2.5 to 13.2.9 [Release 13.2]
Information in this document applies to any platform.


When attempting to edit a partner in a French language environment and the partner description in table CODE_DETAIL has special characters in the name, the following error occurs:

Steps to Reproduce:

  1. Set the environment of RMS to be in French.
  2. Edit a partner which has a special French character as 'é' in CODE_DETAIL.CODE_DESC table.
  3. Go to Options > Expenses, and try to perform any transaction on [expprof] form and note the error.


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