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 NOVEMBER 22, 2017

Applies to:

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

Symptoms

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.

Changes

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

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