My Oracle Support Banner

GUI EDR Viewer Error: java.sql.BatchUpdateException: ORA-06502: PL/SQL: numeric or value error: character string buffer too small (Doc ID 2330711.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Communications Network Charging and Control - Version 5.0.3 and later
Information in this document applies to any platform.


On Oracle Communications Network Charging and Control(OCNCC) from the Service Management System(SMS) Graphical User Interface(GUI) when trying to add extra columns to be displayed in the Event Detail Record(EDR) the following error is seen:

Steps to reproduce:
From the SMS GUI go to: Services -> Prepaid Charging -> EDR Management and then clicking on the EDR viewer columns tab.
When trying to add an extra column an error is returned.

This works  fine on OCNCC 5.0.2 environment.


The datatype of CHANGE_TERM column from CCS_ADMIN.CCS_EDR_VIEWER_COLUMNS table is set to CHAR(12 CHAR).


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.