REL Update Procedure Fails Processing EVENT_ESSENTIALS With "ORA-06502: PL/SQL: numeric or value error: character to number conversion error" (Doc ID 408608.1)

Last updated on MARCH 30, 2017

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.0.0.0.1 and later
Oracle Solaris on SPARC (32-bit)
Solaris Operating System (SPARC)
Checked for relevance on 02-08-2008


Symptoms

The problem happens with the Billing and Revenue Manger (BRM) software when the Rated Event Loader (REL) is used to load a rated event into the BRM database. The following sequence of error messages is shown :

this ultimately shows that the locale language configuration is wrong.

Changes

This problem may happen if the environment (ex. Solaris) "Locale" settings are modified, if the pin_rel startup script is modified, or if the database session "NLS_TERRITORY" is more generally altered to a value different from AMERICA.

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