REL Update Procedure Fails Processing EVENT_ESSENTIALS With "ORA-06502: PL/SQL: numeric or value error: character to number conversion error"
Last updated on MARCH 30, 2017
Applies to:Oracle Communications Billing and Revenue Management - Version 126.96.36.199.1 and later
Oracle Solaris on SPARC (32-bit)
Solaris Operating System (SPARC)
Checked for relevance on 02-08-2008
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.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms