For Non English User, "ORA-6502: PL/SQL: numeric or value error" Is Reported When Selecting Codes in the Item / Supplier / Country Screen and in Order Head Screen

(Doc ID 2169845.1)

Last updated on AUGUST 11, 2016

Applies to:

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

Symptoms

For non-English users, during order creation “ORA-06502: PL/SQL: NUMERIC OR VALUE ERROR” is encountered.

Steps to Recreate:

  1. For non English users,From the main menu, select Ordering > Orders. The Item Search window opens.
  2. In the Action field, select New Order.
  3. Enter details. The Order Creation window opens.
  4. Notice PL/SQL error “ORA-06502: PL/SQL: NUMERIC OR VALUE ERROR”

Cause

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