GUI EDR Viewer Error: java.sql.BatchUpdateException: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
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.
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).
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